[Home] [Help]
1786: t_document_header_id(i),
1787: t_document_distribution_id(i),
1788: t_entered_dr(i),
1789: t_entered_cr(i),
1790: gms_bc_packets_s.nextval,
1791: g_request_id,
1792: t_person_id(i),
1793: t_job_id(i),
1794: t_expenditure_category(i),
1852: vendor_id,
1853: expenditure_category, --Bug: 5003642
1854: revenue_category) values --Bug: 5003642
1855: (p_bc_pkt.packet_id,
1856: gms_bc_packets_s.nextval,
1857: p_bc_pkt.document_header_id,
1858: p_bc_pkt.document_distribution_id,
1859: p_bc_pkt.Document_type,
1860: p_bc_pkt.project_id,
2269: p_request_id IN NUMBER) is
2270: Begin
2271: g_error_stage := 'Update_GMS_BC_Packets...start';
2272: IF g_debug_context = 'Y' THEN
2273: gms_error_pkg.gms_debug ('Update GMS BC Packets start..', 'C');
2274: END IF;
2275:
2276: -- If this procedure is called from interface then we need to use
2277: -- request_id for update ...
2325: Type tab_billable_flag is table of pa_cost_distribution_lines_all.billable_flag%TYPE;
2326: Type tab_line_num is table of pa_cost_distribution_lines_all.line_num%TYPE;
2327: Type tab_rlmi is table of gms_bc_packets.resource_list_member_id%TYPE;
2328: Type tab_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
2329: Type tab_status_code is table of gms_bc_packets.status_code%TYPE;
2330: Type tab_row_id is table of varchar2(30);
2331:
2332: v_ind_compiled_set_id tt_ind_compiled_set_id;
2333: v_billable_flag tab_billable_flag;
3023: gbc.OVERRIDE_AMOUNT,
3024: gbc.EFFECT_ON_FUNDS_CODE ,
3025: gbc.RESULT_CODE,
3026: gbc.gl_bc_packets_rowid,
3027: gms_bc_packets_s.nextval,
3028: gbc.BC_PACKET_ID,
3029: gbc.vendor_id,
3030: gbc.request_id,
3031: gbc.ind_compiled_set_id,