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_API dependencies on PA_TRANSACTIONS

Line 569: x_exp_item_id := PA_TRANSACTIONS.TfrEiTab(i);

565: AND (source_award_id IS NOT NULL OR dest_award_id IS NOT NULL) THEN
566:
567: FOR i IN 1..X_ROWS LOOP
568:
569: x_exp_item_id := PA_TRANSACTIONS.TfrEiTab(i);
570:
571: -- Don't need to store bill_hold_flag in ADL table as Billing process will retrieve this
572: -- value from pa_expenditure_items_all table.
573:

Line 1021: if PA_TRANSACTIONS.EiTrxSrcTab(1) in ('AP INVOICE', 'AP DISCOUNTS',

1017: /* check the transaction source. If it is any of Supplier Costs related do not
1018: process. They'll be processed in gms_pa_costing_pkg now. Bug : 2750896 */
1019:
1020: if Rows > 0 then
1021: if PA_TRANSACTIONS.EiTrxSrcTab(1) in ('AP INVOICE', 'AP DISCOUNTS',
1022: 'AP NRTAX', 'AP EXPENSE', 'AP ERV') then /* Bug 5284323 */
1023: return;
1024: end if;
1025: end if;

Line 1038: x_invoice_id := to_number(PA_TRANSACTIONS.Cdlsr2Tab(i)) ;

1034:
1035: -- --------------------------
1036: -- LOAD VARIABLES.
1037: -- --------------------------
1038: x_invoice_id := to_number(PA_TRANSACTIONS.Cdlsr2Tab(i)) ;
1039: X_dist_lno := to_number(PA_TRANSACTIONS.Cdlsr3Tab(i));
1040: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1041: X_ei_id := PA_TRANSACTIONS.EiIdTab(i);
1042: X_exp_id := PA_TRANSACTIONS.EIdTab(i) ;

Line 1039: X_dist_lno := to_number(PA_TRANSACTIONS.Cdlsr3Tab(i));

1035: -- --------------------------
1036: -- LOAD VARIABLES.
1037: -- --------------------------
1038: x_invoice_id := to_number(PA_TRANSACTIONS.Cdlsr2Tab(i)) ;
1039: X_dist_lno := to_number(PA_TRANSACTIONS.Cdlsr3Tab(i));
1040: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1041: X_ei_id := PA_TRANSACTIONS.EiIdTab(i);
1042: X_exp_id := PA_TRANSACTIONS.EIdTab(i) ;
1043: X_bill_hold_flag := PA_TRANSACTIONS.BillHoldTab(i) ;

Line 1040: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);

1036: -- LOAD VARIABLES.
1037: -- --------------------------
1038: x_invoice_id := to_number(PA_TRANSACTIONS.Cdlsr2Tab(i)) ;
1039: X_dist_lno := to_number(PA_TRANSACTIONS.Cdlsr3Tab(i));
1040: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1041: X_ei_id := PA_TRANSACTIONS.EiIdTab(i);
1042: X_exp_id := PA_TRANSACTIONS.EIdTab(i) ;
1043: X_bill_hold_flag := PA_TRANSACTIONS.BillHoldTab(i) ;
1044: X_project_id := PA_TRANSACTIONS.ProjIdTab(i);

Line 1041: X_ei_id := PA_TRANSACTIONS.EiIdTab(i);

1037: -- --------------------------
1038: x_invoice_id := to_number(PA_TRANSACTIONS.Cdlsr2Tab(i)) ;
1039: X_dist_lno := to_number(PA_TRANSACTIONS.Cdlsr3Tab(i));
1040: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1041: X_ei_id := PA_TRANSACTIONS.EiIdTab(i);
1042: X_exp_id := PA_TRANSACTIONS.EIdTab(i) ;
1043: X_bill_hold_flag := PA_TRANSACTIONS.BillHoldTab(i) ;
1044: X_project_id := PA_TRANSACTIONS.ProjIdTab(i);
1045: X_task_id := PA_TRANSACTIONS.TskidTab(i);

Line 1042: X_exp_id := PA_TRANSACTIONS.EIdTab(i) ;

1038: x_invoice_id := to_number(PA_TRANSACTIONS.Cdlsr2Tab(i)) ;
1039: X_dist_lno := to_number(PA_TRANSACTIONS.Cdlsr3Tab(i));
1040: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1041: X_ei_id := PA_TRANSACTIONS.EiIdTab(i);
1042: X_exp_id := PA_TRANSACTIONS.EIdTab(i) ;
1043: X_bill_hold_flag := PA_TRANSACTIONS.BillHoldTab(i) ;
1044: X_project_id := PA_TRANSACTIONS.ProjIdTab(i);
1045: X_task_id := PA_TRANSACTIONS.TskidTab(i);
1046: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);

Line 1043: X_bill_hold_flag := PA_TRANSACTIONS.BillHoldTab(i) ;

1039: X_dist_lno := to_number(PA_TRANSACTIONS.Cdlsr3Tab(i));
1040: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1041: X_ei_id := PA_TRANSACTIONS.EiIdTab(i);
1042: X_exp_id := PA_TRANSACTIONS.EIdTab(i) ;
1043: X_bill_hold_flag := PA_TRANSACTIONS.BillHoldTab(i) ;
1044: X_project_id := PA_TRANSACTIONS.ProjIdTab(i);
1045: X_task_id := PA_TRANSACTIONS.TskidTab(i);
1046: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1047: x_trx_src := PA_TRANSACTIONS.EiTrxSrcTab(i) ;

Line 1044: X_project_id := PA_TRANSACTIONS.ProjIdTab(i);

1040: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1041: X_ei_id := PA_TRANSACTIONS.EiIdTab(i);
1042: X_exp_id := PA_TRANSACTIONS.EIdTab(i) ;
1043: X_bill_hold_flag := PA_TRANSACTIONS.BillHoldTab(i) ;
1044: X_project_id := PA_TRANSACTIONS.ProjIdTab(i);
1045: X_task_id := PA_TRANSACTIONS.TskidTab(i);
1046: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1047: x_trx_src := PA_TRANSACTIONS.EiTrxSrcTab(i) ;
1048: x_exp_item_date := PA_TRANSACTIONS.EiDateTab(i) ;

Line 1045: X_task_id := PA_TRANSACTIONS.TskidTab(i);

1041: X_ei_id := PA_TRANSACTIONS.EiIdTab(i);
1042: X_exp_id := PA_TRANSACTIONS.EIdTab(i) ;
1043: X_bill_hold_flag := PA_TRANSACTIONS.BillHoldTab(i) ;
1044: X_project_id := PA_TRANSACTIONS.ProjIdTab(i);
1045: X_task_id := PA_TRANSACTIONS.TskidTab(i);
1046: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1047: x_trx_src := PA_TRANSACTIONS.EiTrxSrcTab(i) ;
1048: x_exp_item_date := PA_TRANSACTIONS.EiDateTab(i) ;
1049: --x_burden_award_id := to_number(PA_TRANSACTIONS.Att1Tab(i)) ; -- Bug 2775237, Moved it below

Line 1046: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);

1042: X_exp_id := PA_TRANSACTIONS.EIdTab(i) ;
1043: X_bill_hold_flag := PA_TRANSACTIONS.BillHoldTab(i) ;
1044: X_project_id := PA_TRANSACTIONS.ProjIdTab(i);
1045: X_task_id := PA_TRANSACTIONS.TskidTab(i);
1046: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1047: x_trx_src := PA_TRANSACTIONS.EiTrxSrcTab(i) ;
1048: x_exp_item_date := PA_TRANSACTIONS.EiDateTab(i) ;
1049: --x_burden_award_id := to_number(PA_TRANSACTIONS.Att1Tab(i)) ; -- Bug 2775237, Moved it below
1050: X_ind_cmpl_set_id := PA_TRANSACTIONS.TpIndCompiledSetIdTab(i) ;

Line 1047: x_trx_src := PA_TRANSACTIONS.EiTrxSrcTab(i) ;

1043: X_bill_hold_flag := PA_TRANSACTIONS.BillHoldTab(i) ;
1044: X_project_id := PA_TRANSACTIONS.ProjIdTab(i);
1045: X_task_id := PA_TRANSACTIONS.TskidTab(i);
1046: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1047: x_trx_src := PA_TRANSACTIONS.EiTrxSrcTab(i) ;
1048: x_exp_item_date := PA_TRANSACTIONS.EiDateTab(i) ;
1049: --x_burden_award_id := to_number(PA_TRANSACTIONS.Att1Tab(i)) ; -- Bug 2775237, Moved it below
1050: X_ind_cmpl_set_id := PA_TRANSACTIONS.TpIndCompiledSetIdTab(i) ;
1051: X_Billable_flag := PA_TRANSACTIONS.BillFlagTab(i); -- Added, Bug 1756179

Line 1048: x_exp_item_date := PA_TRANSACTIONS.EiDateTab(i) ;

1044: X_project_id := PA_TRANSACTIONS.ProjIdTab(i);
1045: X_task_id := PA_TRANSACTIONS.TskidTab(i);
1046: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1047: x_trx_src := PA_TRANSACTIONS.EiTrxSrcTab(i) ;
1048: x_exp_item_date := PA_TRANSACTIONS.EiDateTab(i) ;
1049: --x_burden_award_id := to_number(PA_TRANSACTIONS.Att1Tab(i)) ; -- Bug 2775237, Moved it below
1050: X_ind_cmpl_set_id := PA_TRANSACTIONS.TpIndCompiledSetIdTab(i) ;
1051: X_Billable_flag := PA_TRANSACTIONS.BillFlagTab(i); -- Added, Bug 1756179
1052: x_exp_org_id := NULL ;

Line 1049: --x_burden_award_id := to_number(PA_TRANSACTIONS.Att1Tab(i)) ; -- Bug 2775237, Moved it below

1045: X_task_id := PA_TRANSACTIONS.TskidTab(i);
1046: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1047: x_trx_src := PA_TRANSACTIONS.EiTrxSrcTab(i) ;
1048: x_exp_item_date := PA_TRANSACTIONS.EiDateTab(i) ;
1049: --x_burden_award_id := to_number(PA_TRANSACTIONS.Att1Tab(i)) ; -- Bug 2775237, Moved it below
1050: X_ind_cmpl_set_id := PA_TRANSACTIONS.TpIndCompiledSetIdTab(i) ;
1051: X_Billable_flag := PA_TRANSACTIONS.BillFlagTab(i); -- Added, Bug 1756179
1052: x_exp_org_id := NULL ;
1053:

Line 1050: X_ind_cmpl_set_id := PA_TRANSACTIONS.TpIndCompiledSetIdTab(i) ;

1046: X_raw_cost := PA_TRANSACTIONS.RawCostTab(i);
1047: x_trx_src := PA_TRANSACTIONS.EiTrxSrcTab(i) ;
1048: x_exp_item_date := PA_TRANSACTIONS.EiDateTab(i) ;
1049: --x_burden_award_id := to_number(PA_TRANSACTIONS.Att1Tab(i)) ; -- Bug 2775237, Moved it below
1050: X_ind_cmpl_set_id := PA_TRANSACTIONS.TpIndCompiledSetIdTab(i) ;
1051: X_Billable_flag := PA_TRANSACTIONS.BillFlagTab(i); -- Added, Bug 1756179
1052: x_exp_org_id := NULL ;
1053:
1054: BEGIN

Line 1051: X_Billable_flag := PA_TRANSACTIONS.BillFlagTab(i); -- Added, Bug 1756179

1047: x_trx_src := PA_TRANSACTIONS.EiTrxSrcTab(i) ;
1048: x_exp_item_date := PA_TRANSACTIONS.EiDateTab(i) ;
1049: --x_burden_award_id := to_number(PA_TRANSACTIONS.Att1Tab(i)) ; -- Bug 2775237, Moved it below
1050: X_ind_cmpl_set_id := PA_TRANSACTIONS.TpIndCompiledSetIdTab(i) ;
1051: X_Billable_flag := PA_TRANSACTIONS.BillFlagTab(i); -- Added, Bug 1756179
1052: x_exp_org_id := NULL ;
1053:
1054: BEGIN
1055: select ei.cost_distributed_flag, NVL( ei.override_to_organization_id, exp.incurred_by_organization_id )

Line 1126: x_burden_award_id := to_number(PA_TRANSACTIONS.Att1Tab(i)) ; -- Bug 2775237

1122: IF L_DEBUG = 'Y' THEN
1123: gms_error_pkg.gms_debug('GMS: Processing X_module = PAXCBCAB, X_calling_process = PA_BURDEN_COSTING', 'C');
1124: gms_error_pkg.gms_debug('GMS: Before PROC_BURDEN_INTERFACE', 'C');
1125: END IF;
1126: x_burden_award_id := to_number(PA_TRANSACTIONS.Att1Tab(i)) ; -- Bug 2775237
1127: PROC_BURDEN_INTERFACE( x_burden_award_id) ;
1128: IF L_DEBUG = 'Y' THEN
1129: gms_error_pkg.gms_debug('GMS: After PROC_BURDEN_INTERFACE', 'C');
1130: END IF;

Line 1146: X_raw_cost := PA_TRANSACTIONS.AcctRawCost(i);

1142: -- --------------------------------------------------
1143: -- We know that in case of supplier invoice
1144: -- AcctRawCost stores the value for the raw cost.
1145: -- --------------------------------------------------
1146: X_raw_cost := PA_TRANSACTIONS.AcctRawCost(i);
1147:
1148: /** AP Lines uptake: Obsoleted PROC_SI_INTERFACE
1149: AP Lines uptake: Obsoleted PROC_SI_INTERFACE **/
1150: