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.PA_FUNDS_CONTROL_PKG1 dependencies on STANDARD

Line 2858: -- for all eligible invoice distribution id's. This cursor fetches data for Standard Invoices

2854: AND bdgttype.budget_amount_code = 'C'
2855: );
2856:
2857: -- R12 Funds Management Uptake : This is the main cursor to fetch records from ap extracts
2858: -- for all eligible invoice distribution id's. This cursor fetches data for Standard Invoices
2859: -- and prepayments. Note : For prepayments there will be multiple lines for each invoice
2860: -- distribution as data is fetched from AP_PREPAY_APP_DISTS.
2861: -- Note : This cursor fetches only the AP dist record ,it doesnt fetch associated
2862: -- PO/RELEASE that has to be unreserved.

Line 2911: -- For standard invoice this is always same as document_distribution_id

2907: 'AP' document_type,
2908: apext.bus_flow_inv_id document_header_id,
2909: apext.aid_invoice_line_number document_line_id,
2910: apext.aid_invoice_dist_id document_distribution_id,
2911: -- For standard invoice this is always same as document_distribution_id
2912: apext.aid_invoice_dist_id invoice_distribution_id,
2913: 'E' actual_flag,
2914: NULL result_code,
2915: 'I' status_code,

Line 2970: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds

2966: ,'ACCRUAL',apext.po_distribution_id
2967: ,'NONREC_TAX',DECODE(apext.SELF_ASSESSED_TAX_FLAG,'Y', NULL,apext.po_distribution_id)
2968: , NULL) ap_po_distribution_id,
2969: apext.aid_accounting_date gl_date,
2970: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
2971: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2972: -- validation.
2973: DECODE(p_bc_mode,'C'
2974: ,DECODE(apext.AID_LINE_TYPE_LOOKUP_CODE

Line 2975: ,'PREPAY','STANDARD'

2971: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2972: -- validation.
2973: DECODE(p_bc_mode,'C'
2974: ,DECODE(apext.AID_LINE_TYPE_LOOKUP_CODE
2975: ,'PREPAY','STANDARD'
2976: ,apext.AID_LINE_TYPE_LOOKUP_CODE)
2977: ,DECODE(apext.SELF_ASSESSED_TAX_FLAG, 'Y','SELF_ASSESSED_TAX', apext.AID_LINE_TYPE_LOOKUP_CODE)) distribution_type,
2978: DECODE(apext.AID_LINE_TYPE_LOOKUP_CODE
2979: ,'ITEM',DECODE(apext.bus_flow_po_entity_code

Line 3418: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds

3414: l_prepay_exists := 'N';
3415: l_stdinvoice_exists := 'N';
3416:
3417: FOR i in 1..g_ap_line_type_lkup.count LOOP
3418: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
3419: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
3420: -- validation.
3421: IF g_ap_line_type_lkup(i) = 'PREPAY' AND p_bc_mode <> 'C' THEN
3422: l_prepay_exists := 'Y';

Line 3426: -- Exit the loop if both prepay and standard invoices exists.

3422: l_prepay_exists := 'Y';
3423: ELSE
3424: l_stdinvoice_exists := 'Y';
3425: END IF;
3426: -- Exit the loop if both prepay and standard invoices exists.
3427: IF l_prepay_exists= 'Y' AND l_stdinvoice_exists = 'Y' THEN
3428: EXIT;
3429: END IF;
3430: