APPS.JE_REVERSE_SALES_LIST_PKG dependencies on JE_UK_SALES_TRX_GT

Line 159: INSERT INTO je_uk_sales_trx_gt

155: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
156: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Sales Amount'||TO_CHAR(ln_sales_amount));
157: END IF;
158: BEGIN
159: INSERT INTO je_uk_sales_trx_gt
160: (
161: je_info_v1,--Identifier
162: je_info_n1,--CustId
163: je_info_v2,--CustNum

Line 189: DELETE je_uk_sales_trx_gt

185: END IF;
186: END;
187: END LOOP; -- End Loop rec_period_range
188: IF ln_total_sales = 0 THEN
189: DELETE je_uk_sales_trx_gt
190: WHERE je_info_v1 = 'CL'
191: AND je_info_n1 = rec_customers.CUSTOMER_ID
192: AND je_info_v2 = rec_customers.CUSTOMER_NUMBER
193: AND je_info_v4 = lv_cust_vat_reg_num;

Line 195: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In DELETE je_uk_sales_trx_gt');

191: AND je_info_n1 = rec_customers.CUSTOMER_ID
192: AND je_info_v2 = rec_customers.CUSTOMER_NUMBER
193: AND je_info_v4 = lv_cust_vat_reg_num;
194: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
195: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In DELETE je_uk_sales_trx_gt');
196: END IF;
197: ELSE
198: BEGIN
199: INSERT INTO je_uk_sales_trx_gt

Line 199: INSERT INTO je_uk_sales_trx_gt

195: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In DELETE je_uk_sales_trx_gt');
196: END IF;
197: ELSE
198: BEGIN
199: INSERT INTO je_uk_sales_trx_gt
200: (
201: je_info_v1,
202: je_info_v2
203: )

Line 213: FND_LOG.STRING(G_LEVEL_EXCEPTION,'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In INSERT je_uk_sales_trx_gt for type CS');

209: lv_dynamic_sales := 'EMPTY';
210: EXCEPTION
211: WHEN others THEN
212: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
213: FND_LOG.STRING(G_LEVEL_EXCEPTION,'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In INSERT je_uk_sales_trx_gt for type CS');
214: END IF;
215: NULL;
216: END;
217: END IF;