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_PA_COSTING_PKG dependencies on PA_TRX_IMPORT

Line 607: and apd.expenditure_item_date >= PA_TRX_IMPORT.G_Profile_Discount_Start_date

603: and b.invoice_distribution_id = g_xface_rec.invoice_distribution_id
604: and b.pay_dist_lookup_code = 'DISCOUNT'
605: and apd.invoice_distribution_id = b.invoice_distribution_id
606: and NVL(apd.historical_flag,'N') <> 'Y'
607: and apd.expenditure_item_date >= PA_TRX_IMPORT.G_Profile_Discount_Start_date
608: and apd.line_type_lookup_code = decode ( PA_TRX_IMPORT.G_discount_Method,
609: 'TAX', decode (apd.line_type_lookup_code,
610: 'TIPV', 'TIPV',
611: 'TERV','TERV',

Line 608: and apd.line_type_lookup_code = decode ( PA_TRX_IMPORT.G_discount_Method,

604: and b.pay_dist_lookup_code = 'DISCOUNT'
605: and apd.invoice_distribution_id = b.invoice_distribution_id
606: and NVL(apd.historical_flag,'N') <> 'Y'
607: and apd.expenditure_item_date >= PA_TRX_IMPORT.G_Profile_Discount_Start_date
608: and apd.line_type_lookup_code = decode ( PA_TRX_IMPORT.G_discount_Method,
609: 'TAX', decode (apd.line_type_lookup_code,
610: 'TIPV', 'TIPV',
611: 'TERV','TERV',
612: 'TRV', 'TRV',

Line 624: and APSAT.EXPENDITURE_ITEM_DATE >= PA_TRX_IMPORT.G_PROFILE_DISCOUNT_START_DATE

620: where B.INVOICE_PAYMENT_ID = G_XFACE_REC.CDL_SYSTEM_REFERENCE4
621: and b.invoice_distribution_id = g_xface_rec.invoice_distribution_id
622: and b.pay_dist_lookup_code = 'DISCOUNT'
623: and APSAT.INVOICE_DISTRIBUTION_ID = B.INVOICE_DISTRIBUTION_ID
624: and APSAT.EXPENDITURE_ITEM_DATE >= PA_TRX_IMPORT.G_PROFILE_DISCOUNT_START_DATE
625: and APSAT.LINE_TYPE_LOOKUP_CODE = DECODE ( PA_TRX_IMPORT.G_DISCOUNT_METHOD,
626: 'TAX', decode (apsat.line_type_lookup_code,
627: 'TIPV', 'TIPV',
628: 'TERV','TERV',

Line 625: and APSAT.LINE_TYPE_LOOKUP_CODE = DECODE ( PA_TRX_IMPORT.G_DISCOUNT_METHOD,

621: and b.invoice_distribution_id = g_xface_rec.invoice_distribution_id
622: and b.pay_dist_lookup_code = 'DISCOUNT'
623: and APSAT.INVOICE_DISTRIBUTION_ID = B.INVOICE_DISTRIBUTION_ID
624: and APSAT.EXPENDITURE_ITEM_DATE >= PA_TRX_IMPORT.G_PROFILE_DISCOUNT_START_DATE
625: and APSAT.LINE_TYPE_LOOKUP_CODE = DECODE ( PA_TRX_IMPORT.G_DISCOUNT_METHOD,
626: 'TAX', decode (apsat.line_type_lookup_code,
627: 'TIPV', 'TIPV',
628: 'TERV','TERV',
629: 'TRV', 'TRV',

Line 672: IF (pa_trx_import.g_finalPaymentId = g_xface_rec.cdl_system_reference4) THEN

668: -- Intializing the amount
669: p_apdist_amt_to_relieve := g_xface_rec.acct_raw_cost + l_disc_amount;
670:
671: -- If final payment relieve total outstanding amount
672: IF (pa_trx_import.g_finalPaymentId = g_xface_rec.cdl_system_reference4) THEN
673:
674: OPEN c_ap_amt;
675: FETCH c_ap_amt INTO l_ap_amt ;
676: CLOSE c_ap_amt;

Line 711: OR (pa_trx_import.g_finalPaymentId = g_xface_rec.cdl_system_reference4) THEN

707:
708: IF (l_adl_fully_paid = 'Y')
709: OR (g_xface_rec.acct_raw_cost < 0 )
710: OR (l_erv_found = 'Y' )
711: OR (pa_trx_import.g_finalPaymentId = g_xface_rec.cdl_system_reference4) THEN
712:
713: p_cash_fc_required := 'Y' ;
714:
715: END IF;

Line 727: IF (pa_trx_import.g_finalPaymentId = g_xface_rec.cdl_system_reference4) THEN

723: -- relieve will be equal to that of payment amount
724: -- 3. IF BRC on AP distribution is less than payment amount then relieve left over BRC
725: -- 5. Update AP distribution ADL with current available BRC and final payment status in tieback
726: --
727: IF (pa_trx_import.g_finalPaymentId = g_xface_rec.cdl_system_reference4) THEN
728: p_apdist_brc_to_relieve := l_ap_outstanding_brc;
729: ELSIF p_apdist_amt_to_relieve < 0 THEN
730: p_apdist_brc_to_relieve := NULL;
731: ELSIF p_apdist_amt_to_relieve >= l_ap_outstanding_brc THEN

Line 1218: IF (NVL(PA_TRX_IMPORT.G_cash_based_accounting,'N') = 'Y' AND

1214: -- then call local procedure to populate amount and BRC variables for paymenmts .
1215: -- IN R12,for cash based accounting historical invoices will be interfaced as
1216: -- invoice distributions itself and NOT the payments.
1217:
1218: IF (NVL(PA_TRX_IMPORT.G_cash_based_accounting,'N') = 'Y' AND
1219: g_xface_rec.cdl_system_reference4 IS NOT NULL) THEN
1220:
1221: CALCULATE_PAYTMENT_BRC (p_adl_fully_paid => l_adl_fully_paid ,
1222: p_erv_found => l_erv_found ,

Line 1257: IF (NVL(PA_TRX_IMPORT.G_cash_based_accounting,'N') = 'Y' AND

1253: l_bc_pkt.budget_version_id := l_budget_version_id;
1254: -- giving credit to AP... Which is okay.
1255: l_bc_pkt.entered_cr := pa_currency.round_currency_amt(g_xface_rec.acct_raw_cost);
1256: l_bc_pkt.entered_dr := 0;
1257: IF (NVL(PA_TRX_IMPORT.G_cash_based_accounting,'N') = 'Y' AND
1258: g_xface_rec.cdl_system_reference4 IS NOT NULL) THEN
1259: l_bc_pkt.entered_cr := l_apdist_amt_to_relieve;
1260: l_bc_pkt.burdenable_raw_cost := -1 * l_apdist_brc_to_relieve;
1261: ELSE

Line 1294: IF (NVL(PA_TRX_IMPORT.G_cash_based_accounting,'N') = 'Y' AND

1290:
1291: -- R12 AP lines uptake : For reversing expneditures BRC and ind_compiled_set_id should be
1292: -- copied from original expenditure
1293:
1294: IF (NVL(PA_TRX_IMPORT.G_cash_based_accounting,'N') = 'Y' AND
1295: g_xface_rec.cdl_system_reference4 IS NOT NULL) THEN
1296: l_bc_pkt.burdenable_raw_cost := l_apdist_brc_to_relieve;
1297: ELSE
1298: -- Bug 5389130

Line 1407: IF (NVL(PA_TRX_IMPORT.G_cash_based_accounting,'N') = 'Y' AND

1403: l_bc_pkt.entered_dr := 0;
1404: l_bc_pkt.effect_on_funds_code := 'I';
1405: END IF;
1406:
1407: IF (NVL(PA_TRX_IMPORT.G_cash_based_accounting,'N') = 'Y' AND
1408: g_xface_rec.cdl_system_reference4 IS NOT NULL) THEN
1409: l_bc_pkt.burdenable_raw_cost := -1 * l_apdist_brc_to_relieve;
1410: ELSE
1411: l_bc_pkt.burdenable_raw_cost := -1 * g_xface_rec.burdenable_raw_cost;

Line 1473: IF (NVL(PA_TRX_IMPORT.G_cash_based_accounting,'N') = 'Y' AND

1469: l_bc_pkt.entered_dr := 0;
1470: l_bc_pkt.effect_on_funds_code := 'D';
1471: END IF;
1472:
1473: IF (NVL(PA_TRX_IMPORT.G_cash_based_accounting,'N') = 'Y' AND
1474: g_xface_rec.cdl_system_reference4 IS NOT NULL) THEN
1475: l_bc_pkt.burdenable_raw_cost := l_apdist_brc_to_relieve;
1476: ELSE
1477: l_bc_pkt.burdenable_raw_cost := t_burdenable_raw_cost(i);

Line 2735: -- from AP. Call is from pa_trx_import.

2731: -- Here check if transaction_source is one of the supported ones and process
2732: -- them.
2733: --
2734: -- This procedure is called for each distribution line being interfaced
2735: -- from AP. Call is from pa_trx_import.
2736: -- p_status = NULL if successful, else error is populated into p_status.
2737: ------------------------------------------------------------------------------
2738:
2739: PROCEDURE Fundscheck_Supplier_Cost( p_transaction_source IN VARCHAR2,

Line 3149: -- Tieback after interface process is done. This is called from pa_trx_import

3145: END IF;
3146: END Populate_Indirect_Cost;
3147:
3148: -------------------------------------------------------------------------------
3149: -- Tieback after interface process is done. This is called from pa_trx_import
3150: -- after Projects is done with their tieback. This processes data for the
3151: -- current request id.
3152: -- Parameters :
3153: -- p_request_id : Request ID of the calling process.

Line 3289: AND trx.cdl_system_reference4= to_char(pa_trx_import.g_finalPaymentId)) --Final payment -- Bug 10071395: Added to_char

3285: AND substr(nvl(pkt.result_code,'P65'), 1, 1)='P'
3286: AND pkt.status_code='P'
3287: AND pkt.document_type='AP'
3288: AND pkt.parent_bc_packet_id IS NULL
3289: AND trx.cdl_system_reference4= to_char(pa_trx_import.g_finalPaymentId)) --Final payment -- Bug 10071395: Added to_char
3290: AND adl.document_type='AP'
3291: AND adl.adl_status='A';
3292:
3293: -- update the status of gms_bc_packets. update expenditure_item_id