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

Line 3106: l_award_number gms_awards.award_number%TYPE;

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

Line 3111: FROM gms_awards

3107: l_installment_number gms_installments.installment_num%TYPE;
3108:
3109: CURSOR award_cursor IS
3110: SELECT award_number
3111: FROM gms_awards
3112: WHERE award_id = x_award_id;
3113:
3114: CURSOR installment_cursor is
3115: SELECT installment_num

Line 3228: FROM gms_awards ga,

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

Line 3250: l_award_id gms_awards.award_id%TYPE;

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