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 GMS_AWARD_DISTRIBUTIONS

Line 77: adl_rec gms_award_distributions%ROWTYPE;

73: -- This will insert a reversed expendtiure_item record and two new expenditure_items records into ADL table.
74: -- =========================================================================================================
75: PROCEDURE GMS_SPLIT (x_expenditure_item_id IN NUMBER ) IS
76:
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

Line 97: from gms_award_distributions adl

93: select DISTINCT award_id -- Fix for bug : 1786003
94: -- , bill_hold_flag -- Don't need to get bill_hold_flag
95: into source_award_id
96: -- ,x_flag
97: from gms_award_distributions adl
98: where adl.expenditure_item_id = x_expenditure_item_id
99: and adl.document_type = 'EXP'
100: and adl_status = 'A' ;
101:

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 362: -- from gms_award_distributions adl

358: --
359: -- 3628872 NMV View Perf issue was fixed.
360: -- and adl.award_set_id in
361: -- (select award_set_id
362: -- from gms_award_distributions adl
363: -- where award_id = source_award_id);
364: --
365:
366: BEGIN

Line 544: adl_rec gms_award_distributions%ROWTYPE;

540: PROCEDURE vert_ADJUST_ITEMS( X_CALLING_PROCESS IN VARCHAR2 ,
541: X_ROWS IN NUMBER,
542: X_status IN OUT NOCOPY NUMBER ) IS
543:
544: adl_rec gms_award_distributions%ROWTYPE;
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

Line 754: x_adl_rec gms_award_distributions%ROWTYPE ;

750: x_sob_id NUMBER ;
751: x_exp_org_id NUMBER ;
752: X_purgeable VARCHAR2(1) ;
753:
754: x_adl_rec gms_award_distributions%ROWTYPE ;
755:
756: -- New variables for performance :
757:
758: v_trx_src varchar2(30) := 'DUMMY';

Line 798: SELECT * from gms_award_distributions

794: -- -----------------------------
795: -- EXISTING ADL RECORD.
796: -- -----------------------------
797: CURSOR C_adlrec is
798: SELECT * from gms_award_distributions
799: where award_set_id = x_award_set_id
800: and adl_status = 'A' ;
801: -- ----------------------------------
802: -- GET max CDL line NUM.

Line 1492: x_rec gms_award_distributions%ROWTYPE ;

1488: x_project_id IN NUMBER,
1489: x_task_id IN NUMBER,
1490: status IN OUT NOCOPY NUMBER ) IS
1491:
1492: x_rec gms_award_distributions%ROWTYPE ;
1493: x_invoice_distribution_id NUMBER ;
1494:
1495: BEGIN
1496:

Line 1576: from gms_award_distributions adl,

1572: -- BUG : 2540841 - Reject supplier invoice dist lines having incorrect ADLS.
1573: -- =============================================================================
1574: cursor c_get_award is
1575: select adl.award_id
1576: from gms_award_distributions adl,
1577: ap_invoice_distributions_all apd
1578: where apd.award_id = adl.award_set_id
1579: and adl.adl_line_num = 1
1580: and adl.adl_status = 'A'

Line 1590: from GMS_AWARD_DISTRIBUTIONS ADL,

1586: -- AP Lines uptake: use invoice_distribution_id instead of distribution_line_number
1587: and apd.invoice_distribution_id = NVL ( adl.invoice_distribution_id, 0)
1588: union /* BUG 14216205 : Added the union for SAT */
1589: select adl.award_id
1590: from GMS_AWARD_DISTRIBUTIONS ADL,
1591: AP_SELF_ASSESSED_TAX_DIST_ALL apsat
1592: where apsat.award_id = adl.award_set_id
1593: and adl.adl_line_num = 1
1594: and adl.adl_status = 'A'

Line 2102: FROM gms_award_distributions

2098: -- bug : 2305048 ( Unable to interface AP to OGA.
2099: -- This is due to multiple active ADLs.
2100: cursor C1 is
2101: SELECT award_id
2102: FROM gms_award_distributions
2103: WHERE award_set_id = x_award_set_id
2104: AND adl_status = 'A'
2105: and adl_line_num = 1 ;
2106: --AND document_type = 'AP'

Line 2123: FROM gms_award_distributions

2119: -- =========================================================================
2120:
2121: cursor C_PO is
2122: SELECT award_id
2123: FROM gms_award_distributions
2124: WHERE award_set_id = x_award_set_id
2125: AND adl_status = 'A'
2126: AND document_type = 'PO'
2127: and adl_line_num = 1 ;

Line 2298: from gms_Award_distributions adl,

2294: --
2295: /* BUG 14216205 : Commented the below code : Starts */
2296: /*select adl.award_id
2297: into l_award_id
2298: from gms_Award_distributions adl,
2299: ap_invoice_distributions_all apd
2300: where apd.invoice_id = l_system_reference2
2301: and apd.invoice_distribution_id = l_system_reference5
2302: and apd.invoice_id = adl.invoice_id

Line 2315: from gms_Award_distributions adl,

2311: /* BUG 14216205 : Added the following Code for SAT : Starts */
2312: begin
2313: select adl.award_id
2314: into l_award_id
2315: from gms_Award_distributions adl,
2316: ap_invoice_distributions_all apd
2317: where apd.invoice_id = l_system_reference2
2318: and apd.invoice_distribution_id = l_system_reference5
2319: and apd.invoice_id = adl.invoice_id

Line 2330: from GMS_AWARD_DISTRIBUTIONS ADL,

2326: EXCEPTION
2327: when NO_DATA_FOUND THEN
2328: select ADL.AWARD_ID
2329: into l_award_id
2330: from GMS_AWARD_DISTRIBUTIONS ADL,
2331: AP_SELF_ASSESSED_TAX_DIST_ALL APSAT
2332: where APSAT.INVOICE_ID = l_system_reference2
2333: and apsat.invoice_distribution_id = l_system_reference5
2334: and apsat.invoice_id = adl.invoice_id

Line 2367: from gms_Award_distributions adl

2363: END IF ;
2364: ELSE
2365: select adl.award_id
2366: into l_award_id
2367: from gms_Award_distributions adl
2368: where adl.expenditure_item_id = p_tran_item_id
2369: and adl.adl_status = 'A'
2370: and adl.document_type = 'EXP'
2371: and adl.adl_line_num = 1

Line 2450: from gms_award_distributions adl ,gms_awards_all aw

2446: Begin
2447:
2448: select aw.status, aw.close_date
2449: into l_award_status ,l_close_date
2450: from gms_award_distributions adl ,gms_awards_all aw
2451: where adl.expenditure_item_id = x_expenditure_item_id
2452: and adl.adl_status = 'A'
2453: and adl.document_type = nvl(x_doc_type, 'EXP') --Bug 5726575
2454: and adl.award_id = aw.award_id

Line 2494: FROM GMS_AWARD_DISTRIBUTIONS

2490: l_award_id NUMBER := NULL; /* Bug 5194265 - Initialized to NULL */
2491:
2492: CURSOR C_AWARD_ID_CUR(p_expenditure_item_id NUMBER) IS
2493: SELECT AWARD_ID
2494: FROM GMS_AWARD_DISTRIBUTIONS
2495: WHERE EXPENDITURE_ITEM_ID = p_expenditure_item_id
2496: AND ADL_LINE_NUM = 1
2497: AND DOCUMENT_TYPE = 'EXP'
2498: AND ADL_STATUS = 'A';

Line 2528: , gms_award_distributions adl

2524: ELSE
2525: SELECT a.award_number
2526: INTO l_award_number
2527: FROM gms_awards_all a
2528: , gms_award_distributions adl
2529: WHERE adl.award_id = a.award_id
2530: AND adl.expenditure_item_id = p_expenditure_item_id
2531: AND adl.adl_line_num = 1
2532: AND adl.adl_status = 'A'