DBA Data[Home] [Help]

APPS.JA_CN_UDR_EXPORT dependencies on JA_CN_UTILITY

Line 21: --| the changes from Ja_Cn_Utility |

17: --| |
18: --| HISTORY |
19: --| 10-Mar-2010 Shujuan Yan Created |
20: --| 17-Mar-2010 Qingyi Wang Modify the code according to |
21: --| the changes from Ja_Cn_Utility |
22: --| 05-Jan-2011 Jianchao Chi Updated for the new solution to change |
23: --| the logic of Voucher Number and Legal |
24: --| Entity |
25: --| 04-May-2011 Chongwu Li Updated, fix bug 12392517 |

Line 152: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'USER_DEFINED_RECORDS',

148: FETCH user_defined_records_cur
149: INTO lv_sub_segment_code, lv_source_code, lv_context_code;
150: EXIT WHEN user_defined_records_cur%NOTFOUND;
151:
152: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'USER_DEFINED_RECORDS',
153: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START);
154:
155: -- Get User-Defined Record Number
156: IF length(lv_sub_segment_code) = 8 THEN

Line 153: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START);

149: INTO lv_sub_segment_code, lv_source_code, lv_context_code;
150: EXIT WHEN user_defined_records_cur%NOTFOUND;
151:
152: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'USER_DEFINED_RECORDS',
153: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START);
154:
155: -- Get User-Defined Record Number
156: IF length(lv_sub_segment_code) = 8 THEN
157: SELECT substr(lv_sub_segment_code, 8, 1)

Line 172: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_NUMBER',

168: /*FND_FILE.put_line( FND_FILE.log
169: , to_char(ln_record_number)
170: );*/
171:
172: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_NUMBER',
173: pv_text_node_value => ln_record_number);
174:
175: -- Get Record Description and Record Name when source is COA
176: IF lv_source_code = 'COA' THEN

Line 241: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_NAME',

237: WHEN NO_DATA_FOUND THEN
238: lv_record_description := '';
239: END;
240: END IF;
241: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_NAME',
242: pv_text_node_value => lv_record_name);
243: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_DESCRIPTION',
244: pv_text_node_value => lv_record_description,
245: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,

Line 243: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_DESCRIPTION',

239: END;
240: END IF;
241: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_NAME',
242: pv_text_node_value => lv_record_name);
243: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_DESCRIPTION',
244: pv_text_node_value => lv_record_description,
245: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
246: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);
247: Ja_Cn_Utility.Add_Fixed_Child_Node(pv_child_tag_name => 'IS_MULTIPLE_LEVEL',

Line 245: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,

241: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_NAME',
242: pv_text_node_value => lv_record_name);
243: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_DESCRIPTION',
244: pv_text_node_value => lv_record_description,
245: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
246: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);
247: Ja_Cn_Utility.Add_Fixed_Child_Node(pv_child_tag_name => 'IS_MULTIPLE_LEVEL',
248: pv_text_node_value => '0',
249: pn_fixed_length => 1);

Line 246: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);

242: pv_text_node_value => lv_record_name);
243: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_DESCRIPTION',
244: pv_text_node_value => lv_record_description,
245: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
246: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);
247: Ja_Cn_Utility.Add_Fixed_Child_Node(pv_child_tag_name => 'IS_MULTIPLE_LEVEL',
248: pv_text_node_value => '0',
249: pn_fixed_length => 1);
250: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_CODE_CONVENTION',

Line 247: Ja_Cn_Utility.Add_Fixed_Child_Node(pv_child_tag_name => 'IS_MULTIPLE_LEVEL',

243: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_DESCRIPTION',
244: pv_text_node_value => lv_record_description,
245: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
246: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);
247: Ja_Cn_Utility.Add_Fixed_Child_Node(pv_child_tag_name => 'IS_MULTIPLE_LEVEL',
248: pv_text_node_value => '0',
249: pn_fixed_length => 1);
250: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_CODE_CONVENTION',
251: pv_text_node_value => null,

Line 250: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_CODE_CONVENTION',

246: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);
247: Ja_Cn_Utility.Add_Fixed_Child_Node(pv_child_tag_name => 'IS_MULTIPLE_LEVEL',
248: pv_text_node_value => '0',
249: pn_fixed_length => 1);
250: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_CODE_CONVENTION',
251: pv_text_node_value => null,
252: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
253: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);
254: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'USER_DEFINED_RECORDS',

Line 252: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,

248: pv_text_node_value => '0',
249: pn_fixed_length => 1);
250: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_CODE_CONVENTION',
251: pv_text_node_value => null,
252: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
253: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);
254: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'USER_DEFINED_RECORDS',
255: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END);
256: END LOOP;

Line 253: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);

249: pn_fixed_length => 1);
250: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_CODE_CONVENTION',
251: pv_text_node_value => null,
252: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
253: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);
254: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'USER_DEFINED_RECORDS',
255: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END);
256: END LOOP;
257: CLOSE user_defined_records_cur;

Line 254: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'USER_DEFINED_RECORDS',

250: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'RECORD_CODE_CONVENTION',
251: pv_text_node_value => null,
252: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
253: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);
254: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'USER_DEFINED_RECORDS',
255: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END);
256: END LOOP;
257: CLOSE user_defined_records_cur;
258: END IF;

Line 255: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END);

251: pv_text_node_value => null,
252: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
253: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO);
254: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'USER_DEFINED_RECORDS',
255: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END);
256: END LOOP;
257: CLOSE user_defined_records_cur;
258: END IF;
259: