[Home] [Help]
1839: t_document_header_id(i),
1840: t_document_distribution_id(i),
1841: t_entered_dr(i),
1842: t_entered_cr(i),
1843: gms_bc_packets_s.nextval,
1844: g_request_id,
1845: t_person_id(i),
1846: t_job_id(i),
1847: t_expenditure_category(i),
1906: expenditure_category, --Bug: 5003642
1907: revenue_category, --Bug: 5003642
1908: txn_interface_id) values -- Bug 9929155: Added txn_interface_id
1909: (p_bc_pkt.packet_id,
1910: gms_bc_packets_s.nextval,
1911: p_bc_pkt.document_header_id,
1912: p_bc_pkt.document_distribution_id,
1913: p_bc_pkt.Document_type,
1914: p_bc_pkt.project_id,
2349: p_request_id IN NUMBER) is
2350: Begin
2351: g_error_stage := 'Update_GMS_BC_Packets...start';
2352: IF g_debug_context = 'Y' THEN
2353: gms_error_pkg.gms_debug ('Update GMS BC Packets start..', 'C');
2354: END IF;
2355:
2356: -- If this procedure is called from interface then we need to use
2357: -- request_id for update ...
2405: Type tab_billable_flag is table of pa_cost_distribution_lines_all.billable_flag%TYPE;
2406: Type tab_line_num is table of pa_cost_distribution_lines_all.line_num%TYPE;
2407: Type tab_rlmi is table of gms_bc_packets.resource_list_member_id%TYPE;
2408: Type tab_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
2409: Type tab_status_code is table of gms_bc_packets.status_code%TYPE;
2410: Type tab_row_id is table of varchar2(30);
2411:
2412: v_ind_compiled_set_id tt_ind_compiled_set_id;
2413: v_billable_flag tab_billable_flag;
3103: gbc.OVERRIDE_AMOUNT,
3104: gbc.EFFECT_ON_FUNDS_CODE ,
3105: gbc.RESULT_CODE,
3106: gbc.gl_bc_packets_rowid,
3107: gms_bc_packets_s.nextval,
3108: gbc.BC_PACKET_ID,
3109: gbc.vendor_id,
3110: gbc.request_id,
3111: gbc.ind_compiled_set_id,