APPS.GMS_FUNDS_POSTING_PKG dependencies on GMS_AWARD_DISTRIBUTIONS

Line 228: -- and gms award distributions table records.

224:
225: -- ================================================================
226: -- STATUS_CODE_UPDATE
227: -- Following procedure will update funds check ststus on BC packets
228: -- and gms award distributions table records.
229: -- ================================================================
230: PROCEDURE status_code_update (p_packet_id NUMBER,
231: p_mode VARCHAR2,
232: p_partial VARCHAR2 DEFAULT 'N') IS

Line 335: UPDATE gms_award_distributions

331:
332: IF bc_records.document_type = 'REQ' THEN
333: g_error_stage := 'UPDATE_ADL:REQ';
334:
335: UPDATE gms_award_distributions
336: SET resource_list_member_id = bc_records.resource_list_member_id,
337: bud_task_id = bc_records.bud_task_id,
338: fc_status = DECODE(P_MODE,'B',FC_STATUS,DECODE (SUBSTR (bc_records.result_code, 1, 1), 'P', 'A', 'R'))
339: WHERE distribution_id = bc_records.document_distribution_id

Line 349: UPDATE gms_award_distributions

345:
346: ELSIF bc_records.document_type = 'PO' THEN
347: g_error_stage := 'UPDATE_ADL:PO';
348:
349: UPDATE gms_award_distributions
350: SET resource_list_member_id = bc_records.resource_list_member_id,
351: bud_task_id = bc_records.bud_task_id,
352: fc_status = DECODE(P_MODE,'B',FC_STATUS,DECODE (SUBSTR (bc_records.result_code, 1, 1), 'P', 'A', 'R'))
353: WHERE po_distribution_id = bc_records.document_distribution_id

Line 363: UPDATE gms_award_distributions

359:
360: ELSIF bc_records.document_type = 'AP' THEN
361: g_error_stage := 'UPDATE_ADL:AP';
362:
363: UPDATE gms_award_distributions
364: SET resource_list_member_id = bc_records.resource_list_member_id,
365: bud_task_id = bc_records.bud_task_id,
366: fc_status = DECODE(P_MODE,'B',FC_STATUS,DECODE (SUBSTR (bc_records.result_code, 1, 1), 'P', 'A', 'R'))
367: WHERE invoice_id = bc_records.document_header_id

Line 405: gms_award_distributions adl,

401:
402: CURSOR c_non_gms_ap_trans IS
403: SELECT gl.packet_id
404: FROM ap_invoice_distributions_all ap,
405: gms_award_distributions adl,
406: pa_projects_all pp,
407: gms_project_types gpt,
408: gl_bc_packets gl
409: WHERE gl.packet_id = p_packet_id