APPS.GMS_BILLING dependencies on GMS_INSTALL

Line 318: from gms_installments a,

314: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
315:
316: Cursor Cur_installment_lock is
317: select a.installment_id
318: from gms_installments a,
319: gms_awards b
320: where b.award_project_id = X_Award_Project_id
321: and a.award_id = b.award_id;
322:

Line 344: from gms_installments

340: Begin
341:
342: Select 1
343: into x_dummy
344: from gms_installments
345: where installment_id = installment_records.installment_id
346: FOR UPDATE NOWAIT;
347: Exception
348: When RESOURCE_BUSY THEN

Line 1274: from gms_installments

1270: OR
1271: (C_Installment_Id is NULL
1272: AND gmf.installment_id in
1273: (select installment_id
1274: from gms_installments
1275: where award_id = X_award_id
1276: and (trunc(end_date_Active) >= trunc(X_Expenditure_item_date))
1277: /* and active_flag = 'Y' Bug 6878405 */
1278: and nvl(billable_flag,'N') = 'Y'

Line 1627: from gms_installments ins,

1623: Cursor Inst_Id is
1624: select ins.installment_id installment_id,
1625: gmf.total_funding_amount total_funding_amount,
1626: decode(X_Calling_Process,'Invoice',nvl(gmf.total_billed_amount,0),'Revenue',nvl(gmf.total_revenue_amount,0)) Inv_Rev_Amount
1627: from gms_installments ins,
1628: gms_summary_project_fundings gmf
1629: where ins.award_id = X_award_id
1630: and trunc(ins.end_date_active) >= trunc(X_Expenditure_item_date)
1631: /* and ins.active_flag = 'Y' Bug 6878405 */

Line 6369: GMS_INSTALLMENTS

6365: Installment_Id,
6366: Start_Date_Active,
6367: End_Date_Active
6368: from
6369: GMS_INSTALLMENTS
6370: where
6371: Award_Id = X_Award_Id
6372: /* and active_flag = 'Y' bug 6878405 */
6373: and nvl(billable_flag,'N') = 'Y'

Line 6470: /* GMS INSTALLATION CHECK */

6466: Fetch gms_awards_cursor into X_award_number,X_award_name, x_awd_id;
6467: Close GMS_AWARDS_CURSOR;
6468: --End of the Code added for bug 1744641
6469:
6470: /* GMS INSTALLATION CHECK */
6471: If gms_install.enabled then
6472:
6473: IF L_DEBUG = 'Y' THEN
6474: gms_error_pkg.gms_debug('GMS INSTALLED -- START AWARD BILLING FOR Award Project:','C');

Line 6471: If gms_install.enabled then

6467: Close GMS_AWARDS_CURSOR;
6468: --End of the Code added for bug 1744641
6469:
6470: /* GMS INSTALLATION CHECK */
6471: If gms_install.enabled then
6472:
6473: IF L_DEBUG = 'Y' THEN
6474: gms_error_pkg.gms_debug('GMS INSTALLED -- START AWARD BILLING FOR Award Project:','C');
6475: gms_error_pkg.gms_debug('X_Project_id:'||X_Project_id,'C');

Line 6474: gms_error_pkg.gms_debug('GMS INSTALLED -- START AWARD BILLING FOR Award Project:','C');

6470: /* GMS INSTALLATION CHECK */
6471: If gms_install.enabled then
6472:
6473: IF L_DEBUG = 'Y' THEN
6474: gms_error_pkg.gms_debug('GMS INSTALLED -- START AWARD BILLING FOR Award Project:','C');
6475: gms_error_pkg.gms_debug('X_Project_id:'||X_Project_id,'C');
6476: END IF;
6477:
6478: -- Bug 1980810 : Added to set currency related global variables

Line 6856: from gms_installments

6852:
6853: /* bug 5242484 - start */
6854: select count(*)
6855: into x_tot_inst_count
6856: from gms_installments
6857: where award_id = X_Award_id
6858: /* and active_flag = 'Y' bug 6878405 */
6859: and nvl(billable_flag,'N') = 'Y';
6860:

Line 7448: End if; -- GMS INSTALLATION CHECK

7444: -- Concurrency Control Code Ends
7445:
7446: COMMIT; -- Commit to release locks on award and expenditures
7447:
7448: End if; -- GMS INSTALLATION CHECK
7449:
7450: IF L_DEBUG = 'Y' THEN
7451: gms_error_pkg.gms_debug('End Award Billing ','C');
7452: END IF;