eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIC_LIFECYCLE_EXTRACT_PKG dependencies on BIC_SUMMARY_EXTRACT_PKG

Line 94: bic_summary_extract_pkg.debug(' entered extract_lifecycle_data + : ');

90: g_lc_end_month := p_end_date ;
91: bic_consolidate_cust_data_pkg.purge_party_summary_data;
92: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
93: Initialize ;
94: bic_summary_extract_pkg.debug(' entered extract_lifecycle_data + : ');
95: IF p_delete_flag = 'N' THEN
96: bic_summary_extract_pkg.extract_periods (
97: add_months(p_start_date ,g_lc_new_cust_period*- 1),
98: p_end_date,

Line 96: bic_summary_extract_pkg.extract_periods (

92: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
93: Initialize ;
94: bic_summary_extract_pkg.debug(' entered extract_lifecycle_data + : ');
95: IF p_delete_flag = 'N' THEN
96: bic_summary_extract_pkg.extract_periods (
97: add_months(p_start_date ,g_lc_new_cust_period*- 1),
98: p_end_date,
99: 'LIFE_CYCLE',
100: 'N',

Line 104: bic_summary_extract_pkg.extract_all_periods(

100: 'N',
101: p_delete_flag,
102: p_org_id);
103: ELSE
104: bic_summary_extract_pkg.extract_all_periods(
105: add_months(p_start_date ,g_lc_new_cust_period*- 1),
106: p_end_date);
107:
108: END IF;

Line 122: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-23);

118: -- write_log('Value of g_lc_granularity_level ' || g_lc_granularity_level,
119: -- 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
120:
121: IF g_lc_granularity_level = 'Year' THEN
122: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-23);
123: END IF;
124: IF g_lc_comparison_type = 'POP' THEN
125: IF g_lc_granularity_level = 'Month' THEN
126: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-1);

Line 126: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-1);

122: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-23);
123: END IF;
124: IF g_lc_comparison_type = 'POP' THEN
125: IF g_lc_granularity_level = 'Month' THEN
126: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-1);
127: ELSIF g_lc_granularity_level = 'Quarter' THEN
128: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-5);
129: ELSIF g_lc_granularity_level = 'Half Year' THEN
130: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-11);

Line 128: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-5);

124: IF g_lc_comparison_type = 'POP' THEN
125: IF g_lc_granularity_level = 'Month' THEN
126: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-1);
127: ELSIF g_lc_granularity_level = 'Quarter' THEN
128: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-5);
129: ELSIF g_lc_granularity_level = 'Half Year' THEN
130: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-11);
131: END IF;
132: ELSIF g_lc_comparison_type = 'YOY' THEN

Line 130: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-11);

126: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-1);
127: ELSIF g_lc_granularity_level = 'Quarter' THEN
128: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-5);
129: ELSIF g_lc_granularity_level = 'Half Year' THEN
130: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-11);
131: END IF;
132: ELSIF g_lc_comparison_type = 'YOY' THEN
133: IF g_lc_granularity_level = 'Month' THEN
134: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-12);

Line 134: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-12);

130: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-11);
131: END IF;
132: ELSIF g_lc_comparison_type = 'YOY' THEN
133: IF g_lc_granularity_level = 'Month' THEN
134: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-12);
135: ELSIF g_lc_granularity_level = 'Quarter' THEN
136: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-14);
137: ELSIF g_lc_granularity_level = 'Half Year' THEN
138: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-17);

Line 136: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-14);

132: ELSIF g_lc_comparison_type = 'YOY' THEN
133: IF g_lc_granularity_level = 'Month' THEN
134: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-12);
135: ELSIF g_lc_granularity_level = 'Quarter' THEN
136: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-14);
137: ELSIF g_lc_granularity_level = 'Half Year' THEN
138: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-17);
139: END IF;
140: END IF;

Line 138: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-17);

134: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-12);
135: ELSIF g_lc_granularity_level = 'Quarter' THEN
136: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-14);
137: ELSIF g_lc_granularity_level = 'Half Year' THEN
138: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-17);
139: END IF;
140: END IF;
141: bic_summary_extract_pkg.extract_all_periods( bic_summary_extract_pkg.g_period_start_date,p_end_date);
142: IF g_measure_for_lc_stage = 'ORDER_NUM' OR g_measure_for_lc_stage = 'ORDER_QTY' THEN

Line 141: bic_summary_extract_pkg.extract_all_periods( bic_summary_extract_pkg.g_period_start_date,p_end_date);

137: ELSIF g_lc_granularity_level = 'Half Year' THEN
138: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-17);
139: END IF;
140: END IF;
141: bic_summary_extract_pkg.extract_all_periods( bic_summary_extract_pkg.g_period_start_date,p_end_date);
142: IF g_measure_for_lc_stage = 'ORDER_NUM' OR g_measure_for_lc_stage = 'ORDER_QTY' THEN
143: bic_summary_extract_pkg.get_sql_sttmnt(g_measure_for_lc_stage ,x_sttmnt ,
144: x_operation_type,x_mult_factor);
145: bic_summary_extract_pkg.run_sql(x_sttmnt);

Line 143: bic_summary_extract_pkg.get_sql_sttmnt(g_measure_for_lc_stage ,x_sttmnt ,

139: END IF;
140: END IF;
141: bic_summary_extract_pkg.extract_all_periods( bic_summary_extract_pkg.g_period_start_date,p_end_date);
142: IF g_measure_for_lc_stage = 'ORDER_NUM' OR g_measure_for_lc_stage = 'ORDER_QTY' THEN
143: bic_summary_extract_pkg.get_sql_sttmnt(g_measure_for_lc_stage ,x_sttmnt ,
144: x_operation_type,x_mult_factor);
145: bic_summary_extract_pkg.run_sql(x_sttmnt);
146: ELSIF g_measure_for_lc_stage = 'SALES' THEN
147: bic_summary_extract_pkg.extract_sales(bic_summary_extract_pkg.g_period_start_date,p_end_date,NULL,'Y');

Line 145: bic_summary_extract_pkg.run_sql(x_sttmnt);

141: bic_summary_extract_pkg.extract_all_periods( bic_summary_extract_pkg.g_period_start_date,p_end_date);
142: IF g_measure_for_lc_stage = 'ORDER_NUM' OR g_measure_for_lc_stage = 'ORDER_QTY' THEN
143: bic_summary_extract_pkg.get_sql_sttmnt(g_measure_for_lc_stage ,x_sttmnt ,
144: x_operation_type,x_mult_factor);
145: bic_summary_extract_pkg.run_sql(x_sttmnt);
146: ELSIF g_measure_for_lc_stage = 'SALES' THEN
147: bic_summary_extract_pkg.extract_sales(bic_summary_extract_pkg.g_period_start_date,p_end_date,NULL,'Y');
148: END IF;
149: write_log('Before Inserting New Customers for Life Cycle ....',

Line 147: bic_summary_extract_pkg.extract_sales(bic_summary_extract_pkg.g_period_start_date,p_end_date,NULL,'Y');

143: bic_summary_extract_pkg.get_sql_sttmnt(g_measure_for_lc_stage ,x_sttmnt ,
144: x_operation_type,x_mult_factor);
145: bic_summary_extract_pkg.run_sql(x_sttmnt);
146: ELSIF g_measure_for_lc_stage = 'SALES' THEN
147: bic_summary_extract_pkg.extract_sales(bic_summary_extract_pkg.g_period_start_date,p_end_date,NULL,'Y');
148: END IF;
149: write_log('Before Inserting New Customers for Life Cycle ....',
150: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
151: IF p_delete_flag = 'N' THEN

Line 152: bic_summary_extract_pkg.extract_periods (

148: END IF;
149: write_log('Before Inserting New Customers for Life Cycle ....',
150: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
151: IF p_delete_flag = 'N' THEN
152: bic_summary_extract_pkg.extract_periods (
153: add_months(p_start_date ,g_lc_new_cust_period*- 1),
154: p_end_date,
155: 'LIFE_CYCLE',
156: 'N',

Line 160: bic_summary_extract_pkg.extract_all_periods(

156: 'N',
157: p_delete_flag,
158: p_org_id);
159: ELSE
160: bic_summary_extract_pkg.extract_all_periods(
161: add_months(p_start_date ,g_lc_new_cust_period*- 1),
162: p_end_date);
163: END IF;
164: x_c_select := Common_Select ;

Line 177: bic_summary_extract_pkg.debug(' exited extract_lifecycle_data - : ');

173: Insert_Others(x_c_select) ;
174: bic_consolidate_cust_data_pkg.populate_status_data(p_start_date, p_end_date, 'LIFE_CYCLE' );
175: bic_consolidate_cust_data_pkg.purge_party_summary_data;
176: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
177: bic_summary_extract_pkg.debug(' exited extract_lifecycle_data - : ');
178: -- bic_summary_extract_pkg.g_period_start_date := p_start_date;
179: COMMIT;
180: EXCEPTION
181: WHEN NO_LC_SETUP_DATA THEN

Line 178: -- bic_summary_extract_pkg.g_period_start_date := p_start_date;

174: bic_consolidate_cust_data_pkg.populate_status_data(p_start_date, p_end_date, 'LIFE_CYCLE' );
175: bic_consolidate_cust_data_pkg.purge_party_summary_data;
176: bic_consolidate_cust_data_pkg.purge_customer_summary_data;
177: bic_summary_extract_pkg.debug(' exited extract_lifecycle_data - : ');
178: -- bic_summary_extract_pkg.g_period_start_date := p_start_date;
179: COMMIT;
180: EXCEPTION
181: WHEN NO_LC_SETUP_DATA THEN
182: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,

Line 184: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,

180: EXCEPTION
181: WHEN NO_LC_SETUP_DATA THEN
182: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
183: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
184: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,
185: 'No records in BIC_LC_SETUP_ALL');
186: ROLLBACK;
187: WHEN NO_LC_PROFILE_DATA THEN
188: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,

Line 190: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,

186: ROLLBACK;
187: WHEN NO_LC_PROFILE_DATA THEN
188: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
189: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
190: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,
191: 'No records in BIC_PROFILE_VALUES_ALL');
192: ROLLBACK;
193: WHEN NO_LC_MEASURE_ID THEN
194: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,

Line 196: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,

192: ROLLBACK;
193: WHEN NO_LC_MEASURE_ID THEN
194: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
195: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
196: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,
197: 'Measure_id not found for LIFE_CYCLE in the table BIC_MEASURES_ALL');
198: ROLLBACK;
199: WHEN OTHERS THEN
200: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,

Line 202: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,'LIFECYCLE data is not extracted : '||SQLERRM);

198: ROLLBACK;
199: WHEN OTHERS THEN
200: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
201: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
202: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,'LIFECYCLE data is not extracted : '||SQLERRM);
203: bic_summary_extract_pkg.g_period_start_date := p_start_date;
204: ROLLBACK;
205: END extract_lifecycle_data ;
206: ----------------------------

Line 203: bic_summary_extract_pkg.g_period_start_date := p_start_date;

199: WHEN OTHERS THEN
200: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
201: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
202: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,'LIFECYCLE data is not extracted : '||SQLERRM);
203: bic_summary_extract_pkg.g_period_start_date := p_start_date;
204: ROLLBACK;
205: END extract_lifecycle_data ;
206: ----------------------------
207: PROCEDURE Insert_New_Cust IS

Line 218: bic_summary_extract_pkg.debug(' entered Insert_New_Cust + : ');

214: ADD_MONTHS(g_lc_st_month,g_lc_new_cust_period*-1 +1 );
215: x_party_id hz_cust_accounts.party_id % TYPE;
216: x_account_established_date hz_cust_accounts.account_established_date % TYPE;
217: BEGIN
218: bic_summary_extract_pkg.debug(' entered Insert_New_Cust + : ');
219: OPEN party_cur;
220: LOOP
221: FETCH party_cur INTO x_party_id, x_account_established_date;
222: IF party_cur % NOTFOUND THEN

Line 270: bic_summary_extract_pkg.debug(' exited Insert_New_Cust + : ');

266: END LOOP;
267:
268: CLOSE party_cur;
269:
270: bic_summary_extract_pkg.debug(' exited Insert_New_Cust + : ');
271:
272: /*
273: EXCEPTION
274: WHEN DUP_VAL_ON_INDEX THEN

Line 394: bic_summary_extract_pkg.debug(' entered Insert_Insig_Cust + : ');

390: x_cust_id t_cust_id ;
391:
392: BEGIN
393:
394: bic_summary_extract_pkg.debug(' entered Insert_Insig_Cust + : ');
395: x_s1 := 'SELECT start_date, customer_id FROM (' ;
396: x_s := ' < ' || TO_CHAR(g_lc_insig_level) || ' AND value_p2 < '
397: || TO_CHAR(g_lc_insig_level) ;
398:

Line 421: bic_summary_extract_pkg.debug(' exited Insert_Insig_Cust + : ');

417: Insert_Record (NULL, g_lc_measure_id, x_start_date(i), x_cust_id(i), 6) ;
418: ----value = 6 for insignificant customer
419: END LOOP ;
420:
421: bic_summary_extract_pkg.debug(' exited Insert_Insig_Cust + : ');
422:
423: /*
424: EXCEPTION
425: WHEN OTHERS THEN

Line 453: bic_summary_extract_pkg.debug(' entered Insert_Others + : ');

449: x_cust_id t_cust_id ;
450: x_value_p1 t_value_p1 ;
451: x_value_p2 t_value_p2 ;
452: BEGIN
453: bic_summary_extract_pkg.debug(' entered Insert_Others + : ');
454:
455: x_s1 := 'SELECT start_date, customer_id, value_p1, value_p2 FROM (' ;
456: x_s := ' > ' || TO_CHAR(g_lc_insig_level) || ' OR value_p2 > '
457: || TO_CHAR(g_lc_insig_level) ;

Line 496: bic_summary_extract_pkg.debug(' exited Insert_Others + : ');

492: i:=i+1 ;
493:
494: END LOOP ;
495:
496: bic_summary_extract_pkg.debug(' exited Insert_Others + : ');
497:
498: CLOSE x_cur;
499:
500: /*