APPS.GMS_WF_PKG dependencies on GMS_AWARDS

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 2234: from gms_awards ga,

2230: grt.report_name,
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,

Line 2621: from gms_awards ga,

2617: gi.direct_cost,
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

Line 2815: l_award_id gms_awards.award_id%TYPE;

2811: l_commitment_number VARCHAR2(50);
2812: l_commit_document_type VARCHAR2(3);
2813: l_commit_document_type_desc VARCHAR2(80);
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;

Line 2822: l_award_number gms_awards.award_number%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:
2825: l_installment_end_date_text varchar2(60); /*Added for bug:7538344 */
2826: l_user_id number; /*Added for bug:7538344 */

Line 3139: l_award_number gms_awards.award_number%TYPE;

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
3143: SELECT award_number

Line 3144: FROM gms_awards

3140: l_installment_number gms_installments.installment_num%TYPE;
3141:
3142: CURSOR award_cursor IS
3143: SELECT award_number
3144: FROM gms_awards
3145: WHERE award_id = x_award_id;
3146:
3147: CURSOR installment_cursor is
3148: SELECT installment_num

Line 3261: FROM gms_awards ga,

3257: --Cursor to selects all the installments which are going to get closed by the offset number of days
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

Line 3283: l_award_id gms_awards.award_id%TYPE;

3279:
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);