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_EXPENDITURE_ITEMS_ALL

Line 29: G_EXPENDITURE_ITEM_ID PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE := NULL; /* 5490120 */

25: -- ----------------------------------------------------------------------------
26: -- This function returns the error x_error set by the GMS_PA_API.VERT_TRANSFER
27: -- ----------------------------------------------------------------------------
28:
29: G_EXPENDITURE_ITEM_ID PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE := NULL; /* 5490120 */
30: G_AWARD_NUMBER GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL; /* 5490120 */
31:
32: FUNCTION return_error return VARCHAR2 IS
33: begin

Line 81: SELECT * from pa_expenditure_items_all

77: adl_rec gms_award_distributions%ROWTYPE;
78: x_flag varchar2(1);
79: x_billable_flag varchar2(1); -- Bug 1756179
80: CURSOR rev_item(x_expenditure_item_id NUMBER ) IS
81: SELECT * from pa_expenditure_items_all
82: WHERE adjusted_expenditure_item_id = x_expenditure_item_id ;
83:
84: CURSOR new_item(x_expenditure_item_id NUMBER ) IS
85: SELECT * from pa_expenditure_items_all

Line 85: SELECT * from pa_expenditure_items_all

81: SELECT * from pa_expenditure_items_all
82: WHERE adjusted_expenditure_item_id = x_expenditure_item_id ;
83:
84: CURSOR new_item(x_expenditure_item_id NUMBER ) IS
85: SELECT * from pa_expenditure_items_all
86: WHERE transferred_from_exp_item_id = x_expenditure_item_id ;
87:
88: BEGIN
89:

Line 154: update pa_expenditure_items_all

150: adl_rec.created_by := new_rec.created_by;
151: adl_rec.last_update_login := new_rec.last_update_login;
152: gms_awards_dist_pkg.create_adls(adl_rec);
153: -- Start, Bug 1756179
154: update pa_expenditure_items_all
155: set billable_flag = x_billable_flag
156: where expenditure_item_id = new_rec.expenditure_item_id
157: and exists (select 1 from pa_project_types t, pa_projects pa
158: where pa.project_id = SOURCE_PROJECT_ID

Line 252: from pa_expenditure_items_all

248: where award_id = dest_award_id ;
249:
250: CURSOR C_EXP(x_expenditure_item_id IN NUMBER ) IS
251: select expenditure_type,expenditure_item_date
252: from pa_expenditure_items_all
253: where expenditure_item_id = x_expenditure_item_id;
254:
255: x_start_date DATE; -- Bug 2458518
256: x_close_date DATE; -- Bug 2458518

Line 350: from gms_award_distributions adl, pa_expenditure_items_all ex

346:
347: x_exp_item_id NUMBER ;
348:
349: CURSOR c1 is select ex.expenditure_item_id
350: from gms_award_distributions adl, pa_expenditure_items_all ex
351: where ex.expenditure_item_id = x_expenditure_item_id
352: and ex.expenditure_item_id = adl.expenditure_item_id
353: and ex.task_id = adl.task_id
354: and adl.award_id = source_award_id

Line 549: SELECT * from pa_expenditure_items_all

545: x_exp_item_id NUMBER;
546: x_new_item_id NUMBER;
547: x_flag varchar2(1) ;
548: CURSOR rev_item(x_exp_item_id NUMBER ) IS
549: SELECT * from pa_expenditure_items_all
550: WHERE adjusted_expenditure_item_id = x_exp_item_id ;
551:
552: CURSOR new_item(x_exp_item_id NUMBER ) IS
553: SELECT * from pa_expenditure_items_all

Line 553: SELECT * from pa_expenditure_items_all

549: SELECT * from pa_expenditure_items_all
550: WHERE adjusted_expenditure_item_id = x_exp_item_id ;
551:
552: CURSOR new_item(x_exp_item_id NUMBER ) IS
553: SELECT * from pa_expenditure_items_all
554: WHERE transferred_from_exp_item_id = x_exp_item_id ;
555:
556:
557: BEGIN

Line 572: -- value from pa_expenditure_items_all table.

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:
574: /*begin
575: end ;*/
576:

Line 785: pa_expenditure_items_all ei

781: pt.accrual_flag period_end_accrual_flag,
782: pt.system_linkage system_linkage
783: FROM gms_transaction_interface_all gt,
784: pa_transaction_interface_all pt,
785: pa_expenditure_items_all ei
786: WHERE ei.expenditure_item_id = x_ei_id
787: AND ei.expenditure_id = x_exp_id
788: AND ei.transaction_source = x_trx_src
789: and ei.transaction_source = pt.transaction_source

Line 928: from pa_expenditure_items_all ei

924: ld_rec.system_linkage = 'PJ' then
925:
926: select ei.expenditure_item_id
927: into x_adl_rec.expenditure_item_id
928: from pa_expenditure_items_all ei
929: where ei.adjusted_expenditure_item_id = x_ei_id ;
930: IF SQL%FOUND THEN
931: x_adl_rec.raw_cost := X_raw_cost * -1 ;
932: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;

Line 1057: from pa_expenditure_items_all ei,

1053:
1054: BEGIN
1055: select ei.cost_distributed_flag, NVL( ei.override_to_organization_id, exp.incurred_by_organization_id )
1056: into X_costed_flag, x_exp_org_id
1057: from pa_expenditure_items_all ei,
1058: pa_expenditures_all exp
1059: where ei.expenditure_item_id = X_ei_id
1060: and ei.expenditure_id = exp.expenditure_id ;
1061: EXCEPTION

Line 2418: -- join with pa_expenditure_items_all was removed.

2414: --
2415: -- 3134005
2416: -- GMS.L: COMPILATION OF BURDEN SCHEDULE COMPLETES IN ERROR
2417: -- SQL was wrong causing too many rows found
2418: -- join with pa_expenditure_items_all was removed.
2419: --
2420: select t.project_id into l_project_id
2421: from pa_tasks t
2422: where t.task_id = x_task_id ;

Line 2467: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE

2463: this expenditure item.
2464: The function raises an exception if no award is associated with the expenditure item.
2465: */
2466: FUNCTION VERT_GET_AWARD_NUMBER(
2467: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
2468: ) RETURN VARCHAR2 IS
2469: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;
2470: BEGIN
2471: IF p_expenditure_item_id = G_EXPENDITURE_ITEM_ID THEN

Line 2500: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE

2496: If award range is not specified, then the function returns 'Y'.
2497: If award range is specified, then the function returns 'N'.
2498: */
2499: FUNCTION VERT_IS_AWARD_WITHIN_RANGE(
2500: p_expenditure_item_id IN PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE
2501: ,p_from_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2502: ,p_to_award_number IN GMS_AWARDS_ALL.AWARD_NUMBER%TYPE DEFAULT NULL
2503: ) RETURN VARCHAR2 IS
2504: l_award_number GMS_AWARDS_ALL.AWARD_NUMBER%TYPE := NULL;