DBA Data[Home] [Help]

APPS.JA_CN_ACP_EXPORT_PKG dependencies on JA_CN_UTILITY

Line 90: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD',

86: ln_row_count := 0;
87: FOR v_row IN accounting_periods_cur(pn_accounting_year, pn_ledger_id)
88: LOOP
89: ln_row_count := ln_row_count + 1;
90: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD',
91: Ja_Cn_Utility.GV_TAG_TYPE_START);
92: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
93: ,v_row.period_year
94: ,4);

Line 91: Ja_Cn_Utility.GV_TAG_TYPE_START);

87: FOR v_row IN accounting_periods_cur(pn_accounting_year, pn_ledger_id)
88: LOOP
89: ln_row_count := ln_row_count + 1;
90: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD',
91: Ja_Cn_Utility.GV_TAG_TYPE_START);
92: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
93: ,v_row.period_year
94: ,4);
95: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'

Line 92: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'

88: LOOP
89: ln_row_count := ln_row_count + 1;
90: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD',
91: Ja_Cn_Utility.GV_TAG_TYPE_START);
92: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
93: ,v_row.period_year
94: ,4);
95: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
96: ,v_row.period_num);

Line 95: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'

91: Ja_Cn_Utility.GV_TAG_TYPE_START);
92: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
93: ,v_row.period_year
94: ,4);
95: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
96: ,v_row.period_num);
97: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
98: ,to_char(v_row.start_date
99: ,'YYYYMMDD')

Line 97: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'

93: ,v_row.period_year
94: ,4);
95: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
96: ,v_row.period_num);
97: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
98: ,to_char(v_row.start_date
99: ,'YYYYMMDD')
100: ,8);
101: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'

Line 101: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'

97: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
98: ,to_char(v_row.start_date
99: ,'YYYYMMDD')
100: ,8);
101: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
102: ,to_char(v_row.end_date, 'YYYYMMDD')
103: ,8);
104: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
105: ,Ja_Cn_Utility.GV_TAG_TYPE_END);

Line 104: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'

100: ,8);
101: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
102: ,to_char(v_row.end_date, 'YYYYMMDD')
103: ,8);
104: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
105: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
106:
107: END LOOP;
108:

Line 105: ,Ja_Cn_Utility.GV_TAG_TYPE_END);

101: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
102: ,to_char(v_row.end_date, 'YYYYMMDD')
103: ,8);
104: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
105: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
106:
107: END LOOP;
108:
109: IF (ln_row_count = 0)

Line 111: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ACCOUNTING_PERIOD');

107: END LOOP;
108:
109: IF (ln_row_count = 0)
110: THEN
111: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ACCOUNTING_PERIOD');
112: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
113: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
114: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
115: ,NULL

Line 112: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'

108:
109: IF (ln_row_count = 0)
110: THEN
111: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ACCOUNTING_PERIOD');
112: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
113: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
114: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
115: ,NULL
116: ,4);

Line 113: ,Ja_Cn_Utility.GV_TAG_TYPE_START);

109: IF (ln_row_count = 0)
110: THEN
111: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ACCOUNTING_PERIOD');
112: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
113: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
114: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
115: ,NULL
116: ,4);
117: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'

Line 114: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'

110: THEN
111: Ja_Cn_Utility.Print_No_Data_Found_For_Log('ACCOUNTING_PERIOD');
112: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
113: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
114: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
115: ,NULL
116: ,4);
117: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
118: ,NULL);

Line 117: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'

113: ,Ja_Cn_Utility.GV_TAG_TYPE_START);
114: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
115: ,NULL
116: ,4);
117: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
118: ,NULL);
119: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
120: ,NULL
121: ,8);

Line 119: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'

115: ,NULL
116: ,4);
117: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
118: ,NULL);
119: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
120: ,NULL
121: ,8);
122: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
123: ,NULL

Line 122: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'

118: ,NULL);
119: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_START_DATE'
120: ,NULL
121: ,8);
122: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
123: ,NULL
124: ,8);
125: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
126: ,Ja_Cn_Utility.GV_TAG_TYPE_END);

Line 125: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'

121: ,8);
122: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
123: ,NULL
124: ,8);
125: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
126: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
127: END IF; --ln_row_count = 0
128:
129: --logging for debug

Line 126: ,Ja_Cn_Utility.GV_TAG_TYPE_END);

122: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_PERIOD_END_DATE'
123: ,NULL
124: ,8);
125: Ja_Cn_Utility.Add_Sub_Root_Node('ACCOUNTING_PERIOD'
126: ,Ja_Cn_Utility.GV_TAG_TYPE_END);
127: END IF; --ln_row_count = 0
128:
129: --logging for debug
130: IF (ln_proc_level >= ln_dbg_level)