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.GMS_FUNDS_CONTROL_PKG dependencies on AP_PREPAY_APP_DISTS

Line 2347: -- distribution as data is fetched from AP_PREPAY_APP_DISTS.

2343:
2344: -- R12 Funds Management Uptake : This is the main cursor to fetch records from ap extracts
2345: -- for all eligible invoice distribution id's. This cursor fetches data for Standard Invoices
2346: -- and prepayments. Note : For prepayments there will be multiple lines for each invoice
2347: -- distribution as data is fetched from AP_PREPAY_APP_DISTS.
2348: -- Note : This cursor fetches only the AP dist record ,it doesnt fetch associated
2349: -- PO/RELEASE that has to be unreserved.
2350:
2351: /* AP's amount calculation logic for all type of invoices

Line 2461: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice

2457: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2458: /* AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) */
2459: AND apext.event_id = PBXEG.EVENT_ID
2460: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
2461: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2462: -- validation.
2463: /* Commenting the following condition for Bug 5645290
2464: AND (p_mode ='C' OR (apext.aid_line_type_lookup_code <> 'PREPAY' AND p_mode <>'C')) */
2465: /* Adding for Bug 5645290*/

Line 2568: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice

2564: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2565: /* AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) */
2566: AND apext.event_id = PBXEG.EVENT_ID
2567: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
2568: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2569: -- validation.
2570: /* Commenting the following condition for Bug 5645290
2571: AND (p_mode ='C' OR (apext.aid_line_type_lookup_code <> 'PREPAY' AND p_mode <>'C')) */
2572: /* Adding for Bug 5645290*/

Line 2628: AP_PREPAY_APP_DISTS APAD,

2624: APAD.prepay_app_dist_id ap_prepay_app_dist_id
2625: -- Last col. will be used in Synch_gms_gl_packets ...
2626: FROM AP_PREPAY_HISTORY_ALL APPH,
2627: PSA_BC_XLA_EVENTS_GT PBXEG,
2628: AP_PREPAY_APP_DISTS APAD,
2629: AP_INVOICE_LINES_ALL AIL,
2630: AP_INVOICE_DISTRIBUTIONS_ALL AID
2631: WHERE AID.bc_event_id = APPH.bc_Event_id
2632: AND APPH.prepay_history_id = APAD.prepay_history_id

Line 2984: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice

2980: l_stdinvoice_exists := 'N';
2981:
2982: FOR i in 1..g_ap_line_type_lkup.count LOOP
2983: -- Prepayment application will be treated as standard invoice line for check funds
2984: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2985: -- validation.
2986: IF g_ap_line_type_lkup(i) = 'PREPAY' AND p_mode <> 'C' THEN
2987: l_prepay_exists := 'Y';
2988: ELSE

Line 8604: -- This is reqd. as we cannot access ap_prepay_app_dists here .. autonomous ..

8600: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: glbcrec.source_distribution_type:'|| glbcrec.source_distribution_type,'C');
8601: END IF;
8602:
8603: If glbcrec.source_distribution_type = 'AP_PREPAY' then
8604: -- This is reqd. as we cannot access ap_prepay_app_dists here .. autonomous ..
8605:
8606: IF g_debug = 'Y' THEN
8607: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: Derive prepay dist id ','C');
8608: END IF;

Line 8617: -- basically, if ap_prepay_app_dists.ap_prepay_dist_id is same as in gl

8613: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: g_ap_prepay_app_dist_id(x)'||g_ap_prepay_app_dist_id(x),'C');
8614: END IF;
8615:
8616: IF g_ap_prepay_app_dist_id(x) = glbcrec.source_distribution_id_num_1 then
8617: -- basically, if ap_prepay_app_dists.ap_prepay_dist_id is same as in gl
8618: -- assign ap_prepay_app_dists.invoice_distribution_id to l_dist_id
8619:
8620: l_dist_id := g_doc_dist_id_tab(x);
8621:

Line 8618: -- assign ap_prepay_app_dists.invoice_distribution_id to l_dist_id

8614: END IF;
8615:
8616: IF g_ap_prepay_app_dist_id(x) = glbcrec.source_distribution_id_num_1 then
8617: -- basically, if ap_prepay_app_dists.ap_prepay_dist_id is same as in gl
8618: -- assign ap_prepay_app_dists.invoice_distribution_id to l_dist_id
8619:
8620: l_dist_id := g_doc_dist_id_tab(x);
8621:
8622: If g_debug = 'Y' THEN

Line 8656: -- Following cannot be used as ap_prepay_app_dists not visible ..autonomous ..

8652: and (( gbc.document_distribution_id = glbcrec.source_distribution_id_num_1
8653: AND glbcrec.source_distribution_type <> 'AP_PREPAY') OR
8654: (glbcrec.source_distribution_type = 'AP_PREPAY' AND -- Bug 5561741
8655: gbc.document_distribution_id = l_dist_id
8656: -- Following cannot be used as ap_prepay_app_dists not visible ..autonomous ..
8657: -- (SELECT APAD.PREPAY_APP_DISTRIBUTION_ID
8658: -- FROM ap_prepay_app_dists APAD
8659: -- WHERE APAD.PREPAY_APP_DIST_ID = glbcrec.source_distribution_id_num_1 )
8660: ))

Line 8658: -- FROM ap_prepay_app_dists APAD

8654: (glbcrec.source_distribution_type = 'AP_PREPAY' AND -- Bug 5561741
8655: gbc.document_distribution_id = l_dist_id
8656: -- Following cannot be used as ap_prepay_app_dists not visible ..autonomous ..
8657: -- (SELECT APAD.PREPAY_APP_DISTRIBUTION_ID
8658: -- FROM ap_prepay_app_dists APAD
8659: -- WHERE APAD.PREPAY_APP_DIST_ID = glbcrec.source_distribution_id_num_1 )
8660: ))
8661: and gbc.document_type = decode(glbcrec.encumbrance_type_key,'Commitment','REQ'
8662: ,'Obligation','PO'