DBA Data[Home] [Help]

APPS.INV_DIAG_RCV_RMA dependencies on RMA_DIAGNOSTICS

Line 214: rma_diagnostics.rma_sql(l_operating_id,l_rma_number,rma1_sql);

210: -------------------------- Fixed Sqls
211: if skip_execution <> 1 then
212: IF l_rma_number IS NOT NULL AND l_operating_id IS NOT NULL AND
213: l_receipt_num IS NULL AND l_org_id IS NULL AND l_line_num IS NULL then
214: rma_diagnostics.rma_sql(l_operating_id,l_rma_number,rma1_sql);
215: END IF;
216:
217: IF l_rma_number IS NOT NULL AND l_operating_id IS NOT NULL AND l_line_num IS NOT NULL
218: AND l_receipt_num IS NULL AND l_org_id IS NULL THEN

Line 219: rma_diagnostics.rma_line_sql(l_operating_id,l_rma_number,l_line_num,rma1_sql);

215: END IF;
216:
217: IF l_rma_number IS NOT NULL AND l_operating_id IS NOT NULL AND l_line_num IS NOT NULL
218: AND l_receipt_num IS NULL AND l_org_id IS NULL THEN
219: rma_diagnostics.rma_line_sql(l_operating_id,l_rma_number,l_line_num,rma1_sql);
220: END IF;
221:
222: IF l_rma_number IS NOT NULL AND l_operating_id IS NOT NULL
223: AND l_receipt_num IS NOT NULL AND l_org_id IS NOT NULL THEN

Line 224: rma_diagnostics.rma_receipt_sql(l_operating_id,l_rma_number,l_receipt_num,l_org_id,rma1_sql) ;

220: END IF;
221:
222: IF l_rma_number IS NOT NULL AND l_operating_id IS NOT NULL
223: AND l_receipt_num IS NOT NULL AND l_org_id IS NOT NULL THEN
224: rma_diagnostics.rma_receipt_sql(l_operating_id,l_rma_number,l_receipt_num,l_org_id,rma1_sql) ;
225: END IF;
226:
227: IF l_receipt_num IS NOT NULL AND l_org_id IS NOT NULL AND
228: l_rma_number IS NOT NULL AND l_operating_id IS NOT NULL AND l_line_num IS NOT NULL THEN