[Home] [Help]
27: IS
28: cursor l_rhiError_csr(x_group_id in number)
29: is
30: select 1
31: from rcv_headers_interface
32: where group_id = x_group_id
33: and processing_status_code = 'ERROR';
34:
35: cursor l_rtiError_csr(x_group_id in number)
41:
42: cursor l_rhiPending_csr(x_group_id in number)
43: is
44: select 1
45: from rcv_headers_interface
46: where group_id = x_group_id
47: and processing_status_code in ('PENDING','RUNNING');
48:
49: cursor l_rtiPending_csr(x_group_id in number)
55:
56: cursor l_rhiExist_csr(x_group_id in number)
57: is
58: select 1
59: from rcv_headers_interface
60: where group_id = x_group_id;
61:
62: cursor l_pieExist_csr(x_group_id in number)
63: is
62: cursor l_pieExist_csr(x_group_id in number)
63: is
64: select 1
65: from po_interface_errors pie1,
66: rcv_headers_interface rhi
67: where rhi.group_id = x_group_id
68: and rhi.header_interface_id = pie1.interface_header_id
69: union all
70: select 1
909: from
910: (
911: select pht.line_number, pht.shipment_number
912: from pos_exasn_lines plnt,
913: rcv_headers_interface rhi,
914: pos_exasn_headers pht
915: where pht.header_id = plnt.header_id
916: and pht.shipment_number = rhi.shipment_num
917: and plnt.vendor_id = rhi.vendor_id
3284: l_lpn_group_id number;
3285: l_header_interface_id number;
3286: BEGIN
3287: select rcv_interface_groups_s.nextval into l_lpn_group_id from dual;
3288: select rcv_headers_interface_s.nextval into l_header_interface_id from dual;
3289:
3290: insert into pos_exasn_headers(
3291: header_id,
3292: lpn_group_id,
3734:
3735: procedure InsertIntoRHI
3736: is
3737: begin
3738: insert into rcv_headers_interface
3739: (HEADER_INTERFACE_ID ,
3740: GROUP_ID ,
3741: PROCESSING_STATUS_CODE ,
3742: RECEIPT_SOURCE_CODE ,