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_BILLING dependencies on GMS_AWARDS

Line 90: l_labor_format_id gms_Awards_all.labor_invoice_format_id%TYPE;

86: X_Non_Labor_format_id IN NUMBER,
87: X_calling_context IN VARCHAR2)
88: RETURN BOOLEAN IS
89: l_dummy number;
90: l_labor_format_id gms_Awards_all.labor_invoice_format_id%TYPE;
91: l_non_labor_format_id gms_Awards_all.non_labor_invoice_format_id%TYPE;
92: Begin
93:
94: If X_calling_context = 'BILLING_PROCESS' then

Line 91: l_non_labor_format_id gms_Awards_all.non_labor_invoice_format_id%TYPE;

87: X_calling_context IN VARCHAR2)
88: RETURN BOOLEAN IS
89: l_dummy number;
90: l_labor_format_id gms_Awards_all.labor_invoice_format_id%TYPE;
91: l_non_labor_format_id gms_Awards_all.non_labor_invoice_format_id%TYPE;
92: Begin
93:
94: If X_calling_context = 'BILLING_PROCESS' then
95:

Line 98: from gms_awards_all a

94: If X_calling_context = 'BILLING_PROCESS' then
95:
96: select a.labor_invoice_format_id, a.non_labor_invoice_format_id
97: into l_labor_format_id,l_non_labor_format_id
98: from gms_awards_all a
99: where a.award_project_id = X_Award_Project_Id;
100:
101: Elsif X_calling_context = 'AWARDS_FORM' then
102:

Line 215: GMS_AWARDS a

211: a.Revenue_Distribution_Rule
212: into
213: X_Award_Rev_Distribution_Rule
214: from
215: GMS_AWARDS a
216: where
217: a.Award_Id =X_Award_Id;
218:
219: if (X_Award_Rev_Distribution_Rule = 'EVENT') then

Line 260: GMS_AWARDS a

256: a.Billing_Distribution_Rule
257: into
258: X_Award_Bill_Distribution_Rule
259: from
260: GMS_AWARDS a
261: where
262: a.Award_Id =X_Award_Id ;
263:
264: if(X_Award_Bill_Distribution_Rule = 'EVENT') then

Line 319: gms_awards b

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:
323: Begin

Line 329: from gms_awards

325: X_Err_Code := 0;
326:
327: Select 1
328: into x_dummy
329: from gms_awards
330: where award_project_id = X_Award_Project_id
331: FOR UPDATE NOWAIT;
332:
333: IF L_DEBUG = 'Y' THEN

Line 1186: from gms_awards_all where award_id = x_award_id ;

1182: -------------------------------------------------------------------------- */
1183:
1184: select award_project_id
1185: into x_award_project_id
1186: from gms_awards_all where award_id = x_award_id ;
1187:
1188:
1189: FOR i in 1..x_inst_cnt
1190: LOOP

Line 2375: GMS_AWARDS b

2371: b.award_id, /*Award_Id*/
2372: a.carrying_out_organization_id
2373: from
2374: PA_PROJECTS_ALL a,
2375: GMS_AWARDS b
2376: where
2377: a.project_id = X_Project_Id and
2378: b.award_project_id = a.project_id ;
2379:

Line 6378: Cursor GMS_AWARDS_CURSOR is

6374: order by End_Date_Active;
6375:
6376: -- Added for Bug 1744641: To Generate errors when an exception occurs
6377: -- during the process of generation of invoice/Revenue.
6378: Cursor GMS_AWARDS_CURSOR is
6379: select
6380: a.Award_number,
6381: a.Award_short_name,
6382: a.award_id

Line 6384: GMS_AWARDS a

6380: a.Award_number,
6381: a.Award_short_name,
6382: a.award_id
6383: from
6384: GMS_AWARDS a
6385: where
6386: a.Award_Project_Id = X_Project_Id;
6387:
6388: /* Fetch Variables for GET_INSTALLMENTS */

Line 6465: open GMS_AWARDS_CURSOR;

6461: SAVEPOINT AWARD_BILLING_BEGIN; -- Added for bug 4243374
6462: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
6463:
6464: -- Code added for bug 1744641
6465: open GMS_AWARDS_CURSOR;
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:

Line 6466: Fetch gms_awards_cursor into X_award_number,X_award_name, x_awd_id;

6462: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
6463:
6464: -- Code added for bug 1744641
6465: open GMS_AWARDS_CURSOR;
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 */

Line 6467: Close GMS_AWARDS_CURSOR;

6463:
6464: -- Code added for bug 1744641
6465: open GMS_AWARDS_CURSOR;
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

Line 6645: nvl(a.hard_limit_flag,'N') -- Bug 1841288 : Taken hard_limit_flag from gms_awards instead of pa_agreements_all

6641: a.Revenue_Distribution_Rule,
6642: a.Billing_Distribution_Rule,
6643: a.Status,
6644: -- ag.Revenue_Limit_Flag -- Bug 1841288
6645: nvl(a.hard_limit_flag,'N') -- Bug 1841288 : Taken hard_limit_flag from gms_awards instead of pa_agreements_all
6646: ,nvl(a.invoice_limit_flag,'N') -- Bug 6642901
6647: into
6648: X_Award_Id, -- Adding this because Revenue Process doesnot have access to GET_FORMAT_SELECT proc.
6649: X_Award_Rev_Distribution_Rule,

Line 6655: GMS_AWARDS a

6651: X_Award_Status,
6652: X_Revenue_Limit_Flag,
6653: X_Invoice_limit_Flag -- Bug 6642901
6654: from
6655: GMS_AWARDS a
6656: --PA_AGREEMENTS_ALL ag -- Bug 1841288 : Removed join from PA_AGREEMENTS_ALL Table
6657: where
6658: a.Award_Project_Id = X_Project_Id;
6659: -- and a.agreement_id = ag.agreement_id; -- Bug 1841288 : Removed the join