eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_ACK_PVT dependencies on OE_BULK_ORDER_PVT

Line 1895: AND item.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG

1891: AND tax_exempt_reason.lookup_code(+) = L.tax_exempt_reason_code
1892: AND tax_point.lookup_type(+) = 'TAX_POINT'
1893: AND tax_point.lookup_code(+) = L.tax_point_code
1894: AND item.inventory_item_id = L.inventory_item_id
1895: AND item.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
1896: ;
1897:
1898: END Insert_Line_Acks;
1899:

Line 1921: l_header_count := OE_BULK_ORDER_PVT.G_HEADER_REC.HEADER_ID.COUNT;

1917: -- For such orders, do not process acks IF:
1918: -- 1. Any one line in the order exists that is NOT scheduled
1919: -- (schedule_ship_date IS NULL)
1920:
1921: l_header_count := OE_BULK_ORDER_PVT.G_HEADER_REC.HEADER_ID.COUNT;
1922:
1923: FOR I IN 1..l_header_count LOOP
1924:
1925: IF OE_BULK_ORDER_PVT.G_HEADER_REC.first_ack_code(i) = 'X'

Line 1925: IF OE_BULK_ORDER_PVT.G_HEADER_REC.first_ack_code(i) = 'X'

1921: l_header_count := OE_BULK_ORDER_PVT.G_HEADER_REC.HEADER_ID.COUNT;
1922:
1923: FOR I IN 1..l_header_count LOOP
1924:
1925: IF OE_BULK_ORDER_PVT.G_HEADER_REC.first_ack_code(i) = 'X'
1926: AND nvl(OE_BULK_ORDER_PVT.G_HEADER_REC.lock_control(i), 0) NOT IN (-99, -98, -97)
1927: AND OE_BULK_ORDER_PVT.G_HEADER_REC.booked_flag(i) = 'Y'
1928: THEN
1929:

Line 1926: AND nvl(OE_BULK_ORDER_PVT.G_HEADER_REC.lock_control(i), 0) NOT IN (-99, -98, -97)

1922:
1923: FOR I IN 1..l_header_count LOOP
1924:
1925: IF OE_BULK_ORDER_PVT.G_HEADER_REC.first_ack_code(i) = 'X'
1926: AND nvl(OE_BULK_ORDER_PVT.G_HEADER_REC.lock_control(i), 0) NOT IN (-99, -98, -97)
1927: AND OE_BULK_ORDER_PVT.G_HEADER_REC.booked_flag(i) = 'Y'
1928: THEN
1929:
1930: l_header_id := OE_BULK_ORDER_PVT.G_HEADER_REC.HEADER_ID(i);

Line 1927: AND OE_BULK_ORDER_PVT.G_HEADER_REC.booked_flag(i) = 'Y'

1923: FOR I IN 1..l_header_count LOOP
1924:
1925: IF OE_BULK_ORDER_PVT.G_HEADER_REC.first_ack_code(i) = 'X'
1926: AND nvl(OE_BULK_ORDER_PVT.G_HEADER_REC.lock_control(i), 0) NOT IN (-99, -98, -97)
1927: AND OE_BULK_ORDER_PVT.G_HEADER_REC.booked_flag(i) = 'Y'
1928: THEN
1929:
1930: l_header_id := OE_BULK_ORDER_PVT.G_HEADER_REC.HEADER_ID(i);
1931:

Line 1930: l_header_id := OE_BULK_ORDER_PVT.G_HEADER_REC.HEADER_ID(i);

1926: AND nvl(OE_BULK_ORDER_PVT.G_HEADER_REC.lock_control(i), 0) NOT IN (-99, -98, -97)
1927: AND OE_BULK_ORDER_PVT.G_HEADER_REC.booked_flag(i) = 'Y'
1928: THEN
1929:
1930: l_header_id := OE_BULK_ORDER_PVT.G_HEADER_REC.HEADER_ID(i);
1931:
1932: Insert_Header_Acks(l_header_id);
1933:
1934: Insert_Line_Acks(l_header_id);

Line 1939: OE_BULK_ORDER_PVT.G_HEADER_REC.order_source_id(i),

1935:
1936: -- Check to see if there are any Rejected lines for the
1937: -- processed headers
1938: Insert_Rejected_Lines_Ack(p_batch_id,
1939: OE_BULK_ORDER_PVT.G_HEADER_REC.order_source_id(i),
1940: OE_BULK_ORDER_PVT.G_HEADER_REC.orig_sys_document_ref(i));
1941:
1942: END IF;
1943:

Line 1940: OE_BULK_ORDER_PVT.G_HEADER_REC.orig_sys_document_ref(i));

1936: -- Check to see if there are any Rejected lines for the
1937: -- processed headers
1938: Insert_Rejected_Lines_Ack(p_batch_id,
1939: OE_BULK_ORDER_PVT.G_HEADER_REC.order_source_id(i),
1940: OE_BULK_ORDER_PVT.G_HEADER_REC.orig_sys_document_ref(i));
1941:
1942: END IF;
1943:
1944: END LOOP;