DBA Data[Home] [Help]

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 6400: GMS_INSTALLMENTS

6396: Installment_Id,
6397: Start_Date_Active,
6398: End_Date_Active
6399: from
6400: GMS_INSTALLMENTS
6401: where
6402: Award_Id = X_Award_Id
6403: /* and active_flag = 'Y' bug 6878405 */
6404: and nvl(billable_flag,'N') = 'Y'

Line 6501: /* GMS INSTALLATION CHECK */

6497: Fetch gms_awards_cursor into X_award_number,X_award_name, x_awd_id;
6498: Close GMS_AWARDS_CURSOR;
6499: --End of the Code added for bug 1744641
6500:
6501: /* GMS INSTALLATION CHECK */
6502: If gms_install.enabled then
6503:
6504: IF L_DEBUG = 'Y' THEN
6505: gms_error_pkg.gms_debug('GMS INSTALLED -- START AWARD BILLING FOR Award Project:','C');

Line 6502: If gms_install.enabled then

6498: Close GMS_AWARDS_CURSOR;
6499: --End of the Code added for bug 1744641
6500:
6501: /* GMS INSTALLATION CHECK */
6502: If gms_install.enabled then
6503:
6504: IF L_DEBUG = 'Y' THEN
6505: gms_error_pkg.gms_debug('GMS INSTALLED -- START AWARD BILLING FOR Award Project:','C');
6506: gms_error_pkg.gms_debug('X_Project_id:'||X_Project_id,'C');

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

6501: /* GMS INSTALLATION CHECK */
6502: If gms_install.enabled then
6503:
6504: IF L_DEBUG = 'Y' THEN
6505: gms_error_pkg.gms_debug('GMS INSTALLED -- START AWARD BILLING FOR Award Project:','C');
6506: gms_error_pkg.gms_debug('X_Project_id:'||X_Project_id,'C');
6507: END IF;
6508:
6509: -- Bug 1980810 : Added to set currency related global variables

Line 6887: from gms_installments

6883:
6884: /* bug 5242484 - start */
6885: select count(*)
6886: into x_tot_inst_count
6887: from gms_installments
6888: where award_id = X_Award_id
6889: /* and active_flag = 'Y' bug 6878405 */
6890: and nvl(billable_flag,'N') = 'Y';
6891:

Line 7479: End if; -- GMS INSTALLATION CHECK

7475: -- Concurrency Control Code Ends
7476:
7477: COMMIT; -- Commit to release locks on award and expenditures
7478:
7479: End if; -- GMS INSTALLATION CHECK
7480:
7481: IF L_DEBUG = 'Y' THEN
7482: gms_error_pkg.gms_debug('End Award Billing ','C');
7483: END IF;