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_WF_PKG dependencies on GMS_INSTALLMENTS

Line 2216: from gms_awards_v ga, gms_installments gi, gms_reports_v grv

2212: grv.report_name,
2213: grv.due_date,
2214: ga.funding_source_short_name,
2215: grv.report_id --bug 2282107
2216: from gms_awards_v ga, gms_installments gi, gms_reports_v grv
2217: where grv.installment_id = gi.installment_id
2218: and gi.award_id = ga.award_id
2219: and grv.due_date = trunc(sysdate) + l_offset_days -- Bug 1868293
2220: and ga.status <> 'CLOSED' --Changed from 'ACTIVE' to fix bug 2200837

Line 2235: gms_installments gi,

2231: gr.due_date,
2232: substrb(party.party_name,1,50) funding_source_short_name,
2233: gr.report_id --bug 2282107
2234: from gms_awards ga,
2235: gms_installments gi,
2236: gms_reports gr,
2237: gms_report_templates grt,
2238: hz_parties party,
2239: hz_cust_accounts cust_acct

Line 2578: l_install_number gms_installments.installment_num%TYPE;

2574: l_funding_source_name varchar2(255);
2575:
2576: -- Bug Fix 2225725
2577: --l_install_number number;
2578: l_install_number gms_installments.installment_num%TYPE;
2579: -- End of Fix
2580:
2581: l_install_start_date date;
2582: l_install_end_date date;

Line 2622: gms_installments gi, hz_parties party,

2618: gi.indirect_cost,
2619: (nvl(gi.direct_cost,0) + nvl(gi.indirect_cost,0)),
2620: gi.description
2621: from gms_awards ga,
2622: gms_installments gi, hz_parties party,
2623: hz_cust_accounts cust_acct
2624: where gi.award_id = ga.award_id
2625: and cust_acct.cust_account_id(+) = ga.funding_source_id
2626: and cust_acct.party_id = party.party_id

Line 2818: l_installment_end_date gms_installments.start_date_active%TYPE;

2814: l_amount NUMBER;
2815: l_award_id gms_awards.award_id%TYPE;
2816: l_project_id gms_encumbrance_items.project_id%TYPE;
2817: l_task_id gms_encumbrance_items.task_id%TYPE;
2818: l_installment_end_date gms_installments.start_date_active%TYPE;
2819: l_installment_start_date gms_installments.end_date_active%TYPE;
2820: l_installment_id gms_installments.installment_id%TYPE;
2821: l_header gms_lookups.meaning%TYPE;
2822: l_award_number gms_awards.award_number%TYPE;

Line 2819: l_installment_start_date gms_installments.end_date_active%TYPE;

2815: l_award_id gms_awards.award_id%TYPE;
2816: l_project_id gms_encumbrance_items.project_id%TYPE;
2817: l_task_id gms_encumbrance_items.task_id%TYPE;
2818: l_installment_end_date gms_installments.start_date_active%TYPE;
2819: l_installment_start_date gms_installments.end_date_active%TYPE;
2820: l_installment_id gms_installments.installment_id%TYPE;
2821: l_header gms_lookups.meaning%TYPE;
2822: l_award_number gms_awards.award_number%TYPE;
2823: l_installment_number gms_installments.installment_num%TYPE;

Line 2820: l_installment_id gms_installments.installment_id%TYPE;

2816: l_project_id gms_encumbrance_items.project_id%TYPE;
2817: l_task_id gms_encumbrance_items.task_id%TYPE;
2818: l_installment_end_date gms_installments.start_date_active%TYPE;
2819: l_installment_start_date gms_installments.end_date_active%TYPE;
2820: l_installment_id gms_installments.installment_id%TYPE;
2821: l_header gms_lookups.meaning%TYPE;
2822: l_award_number gms_awards.award_number%TYPE;
2823: l_installment_number gms_installments.installment_num%TYPE;
2824:

Line 2823: l_installment_number gms_installments.installment_num%TYPE;

2819: l_installment_start_date gms_installments.end_date_active%TYPE;
2820: l_installment_id gms_installments.installment_id%TYPE;
2821: l_header gms_lookups.meaning%TYPE;
2822: l_award_number gms_awards.award_number%TYPE;
2823: l_installment_number gms_installments.installment_num%TYPE;
2824:
2825: l_installment_end_date_text varchar2(60); /*Added for bug:7538344 */
2826: l_user_id number; /*Added for bug:7538344 */
2827:

Line 3137: l_installment_end_date gms_installments.end_date_active%TYPE;

3133:
3134:
3135: ItemType VARCHAR2(30) := 'GMSWF';
3136: ItemKey NUMBER;
3137: l_installment_end_date gms_installments.end_date_active%TYPE;
3138: l_installment_start_date gms_installments.start_date_active%TYPE;
3139: l_award_number gms_awards.award_number%TYPE;
3140: l_installment_number gms_installments.installment_num%TYPE;
3141:

Line 3138: l_installment_start_date gms_installments.start_date_active%TYPE;

3134:
3135: ItemType VARCHAR2(30) := 'GMSWF';
3136: ItemKey NUMBER;
3137: l_installment_end_date gms_installments.end_date_active%TYPE;
3138: l_installment_start_date gms_installments.start_date_active%TYPE;
3139: l_award_number gms_awards.award_number%TYPE;
3140: l_installment_number gms_installments.installment_num%TYPE;
3141:
3142: CURSOR award_cursor IS

Line 3140: l_installment_number gms_installments.installment_num%TYPE;

3136: ItemKey NUMBER;
3137: l_installment_end_date gms_installments.end_date_active%TYPE;
3138: l_installment_start_date gms_installments.start_date_active%TYPE;
3139: l_award_number gms_awards.award_number%TYPE;
3140: l_installment_number gms_installments.installment_num%TYPE;
3141:
3142: CURSOR award_cursor IS
3143: SELECT award_number
3144: FROM gms_awards

Line 3151: FROM gms_installments

3147: CURSOR installment_cursor is
3148: SELECT installment_num
3149: ,end_date_active
3150: ,start_date_active
3151: FROM gms_installments
3152: WHERE installment_id = x_installment_id;
3153:
3154:
3155: BEGIN

Line 3262: gms_installments gi

3258: CURSOR award_install_cursor is
3259: SELECT ga.award_id ,
3260: gi.installment_id
3261: FROM gms_awards ga,
3262: gms_installments gi
3263: WHERE gi.award_id = ga.award_id
3264: AND trunc(gi.end_date_active )= trunc(SYSDATE) + p_offset_days
3265: AND ga.status <> 'CLOSED' -- Change from 'ACTIVE' to fix bug 2200585
3266: AND gi.active_flag = 'Y'

Line 3284: l_installment_id gms_installments.installment_id%TYPE;

3280:
3281: -- Declare the variables Used during the workflow process
3282:
3283: l_award_id gms_awards.award_id%TYPE;
3284: l_installment_id gms_installments.installment_id%TYPE;
3285: l_user_id fnd_user.user_id%TYPE;
3286: l_user_name fnd_user.user_name%TYPE;
3287: l_role_name VARCHAR2(1000);
3288: l_role_name_disp VARCHAR2(1000); -- Fix for NOCOPY related issues.