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: -- Declare a variable to create a new line.

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: -- Declare a variable to create a new line.
2825: NL VARCHAR2(1) := fnd_global.newline;
2826: -- Cursor to fetch all the open commitments attached associated with the award ,project and task combination
2827:

Line 3104: l_installment_end_date gms_installments.end_date_active%TYPE;

3100:
3101:
3102: ItemType VARCHAR2(30) := 'GMSWF';
3103: ItemKey NUMBER;
3104: l_installment_end_date gms_installments.end_date_active%TYPE;
3105: l_installment_start_date gms_installments.start_date_active%TYPE;
3106: l_award_number gms_awards.award_number%TYPE;
3107: l_installment_number gms_installments.installment_num%TYPE;
3108:

Line 3105: l_installment_start_date gms_installments.start_date_active%TYPE;

3101:
3102: ItemType VARCHAR2(30) := 'GMSWF';
3103: ItemKey NUMBER;
3104: l_installment_end_date gms_installments.end_date_active%TYPE;
3105: l_installment_start_date gms_installments.start_date_active%TYPE;
3106: l_award_number gms_awards.award_number%TYPE;
3107: l_installment_number gms_installments.installment_num%TYPE;
3108:
3109: CURSOR award_cursor IS

Line 3107: l_installment_number gms_installments.installment_num%TYPE;

3103: ItemKey NUMBER;
3104: l_installment_end_date gms_installments.end_date_active%TYPE;
3105: l_installment_start_date gms_installments.start_date_active%TYPE;
3106: l_award_number gms_awards.award_number%TYPE;
3107: l_installment_number gms_installments.installment_num%TYPE;
3108:
3109: CURSOR award_cursor IS
3110: SELECT award_number
3111: FROM gms_awards

Line 3118: FROM gms_installments

3114: CURSOR installment_cursor is
3115: SELECT installment_num
3116: ,end_date_active
3117: ,start_date_active
3118: FROM gms_installments
3119: WHERE installment_id = x_installment_id;
3120:
3121:
3122: BEGIN

Line 3229: gms_installments gi

3225: CURSOR award_install_cursor is
3226: SELECT ga.award_id ,
3227: gi.installment_id
3228: FROM gms_awards ga,
3229: gms_installments gi
3230: WHERE gi.award_id = ga.award_id
3231: AND trunc(gi.end_date_active )= trunc(SYSDATE) + p_offset_days
3232: AND ga.status <> 'CLOSED' -- Change from 'ACTIVE' to fix bug 2200585
3233: AND gi.active_flag = 'Y'

Line 3251: l_installment_id gms_installments.installment_id%TYPE;

3247:
3248: -- Declare the variables Used during the workflow process
3249:
3250: l_award_id gms_awards.award_id%TYPE;
3251: l_installment_id gms_installments.installment_id%TYPE;
3252: l_user_id fnd_user.user_id%TYPE;
3253: l_user_name fnd_user.user_name%TYPE;
3254: l_role_name VARCHAR2(1000);
3255: l_role_name_disp VARCHAR2(1000); -- Fix for NOCOPY related issues.