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.PO_PDOI_ITEM_PROCESS_PVT dependencies on PO_PDOI_PARAMS

Line 574: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id

570: po_headers_all txn_headers,
571: po_session_gt gt
572: WHERE gt.num2 = intf_lines.interface_line_id
573: AND intf_lines.interface_line_id = intf_locs.interface_line_id
574: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id
575: AND gt.num3 = draft_headers.po_header_id(+)
576: AND gt.num4 = draft_headers.draft_id(+)
577: AND gt.num3 = txn_headers.po_header_id(+)
578: AND gt.key = l_key

Line 824: (PO_PDOI_PARAMS.g_sys.def_inv_org_id,

820: organization_id,
821: inventory_item_id
822: FROM mtl_system_items_vl
823: WHERE organization_id IN
824: (PO_PDOI_PARAMS.g_sys.def_inv_org_id,
825: PO_PDOI_PARAMS.g_sys.master_inv_org_id,
826: x_items.ship_to_org_id_tbl(i)
827: )
828: AND (concatenated_segments = x_items.ln_item_tbl(i)

Line 825: PO_PDOI_PARAMS.g_sys.master_inv_org_id,

821: inventory_item_id
822: FROM mtl_system_items_vl
823: WHERE organization_id IN
824: (PO_PDOI_PARAMS.g_sys.def_inv_org_id,
825: PO_PDOI_PARAMS.g_sys.master_inv_org_id,
826: x_items.ship_to_org_id_tbl(i)
827: )
828: AND (concatenated_segments = x_items.ln_item_tbl(i)
829: OR inventory_item_id = x_items.ln_item_id_tbl(i)) ; --6956962

Line 853: IF (l_org_id_tbl(i) = PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN

849: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id_tbl(l_index)',
850: x_items.ship_to_org_id_tbl(l_index));
851: END IF;
852:
853: IF (l_org_id_tbl(i) = PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN
854: l_exist_in_inv_org_tbl(l_index) := FND_API.g_TRUE;
855: x_items.ln_item_id_tbl(l_index) := l_item_id_tbl(i);
856: END IF;
857:

Line 858: IF (l_org_id_tbl(i) = PO_PDOI_PARAMS.g_sys.master_inv_org_id) THEN

854: l_exist_in_inv_org_tbl(l_index) := FND_API.g_TRUE;
855: x_items.ln_item_id_tbl(l_index) := l_item_id_tbl(i);
856: END IF;
857:
858: IF (l_org_id_tbl(i) = PO_PDOI_PARAMS.g_sys.master_inv_org_id) THEN
859: l_exist_in_master_org_tbl(l_index) := FND_API.g_TRUE;
860: x_items.ln_item_id_tbl(l_index) := l_item_id_tbl(i);
861: END IF;
862:

Line 896: PO_PDOI_PARAMS.g_sys.master_inv_org_id <>

892: IF (l_exist_in_master_org_tbl(l_index) = FND_API.g_FALSE) THEN
893: x_create_in_master_index_tbl(l_index) := l_index;
894:
895: IF (l_exist_in_inv_org_tbl(l_index) = FND_API.g_FALSE AND
896: PO_PDOI_PARAMS.g_sys.master_inv_org_id <>
897: PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN
898: x_create_in_inv_index_tbl(l_index) := l_index;
899: END IF;
900: END IF;

Line 897: PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN

893: x_create_in_master_index_tbl(l_index) := l_index;
894:
895: IF (l_exist_in_inv_org_tbl(l_index) = FND_API.g_FALSE AND
896: PO_PDOI_PARAMS.g_sys.master_inv_org_id <>
897: PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN
898: x_create_in_inv_index_tbl(l_index) := l_index;
899: END IF;
900: END IF;
901:

Line 907: x_items.ship_to_org_id_tbl(l_index) <> PO_PDOI_PARAMS.g_sys.master_inv_org_id AND

903:
904: -- set flag for whether item needs to be created in ship_to org
905: IF (l_exist_in_ship_to_org_tbl(l_index) = FND_API.g_FALSE AND
906: x_items.ship_to_org_id_tbl(l_index) IS NOT NULL AND
907: x_items.ship_to_org_id_tbl(l_index) <> PO_PDOI_PARAMS.g_sys.master_inv_org_id AND
908: x_items.ship_to_org_id_tbl(l_index) <> PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN
909: x_create_in_ship_to_index_tbl(l_index) := l_index;
910: END IF;
911: ELSIF (x_items.ln_item_id_tbl(l_index) IS NOT NULL) THEN

Line 908: x_items.ship_to_org_id_tbl(l_index) <> PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN

904: -- set flag for whether item needs to be created in ship_to org
905: IF (l_exist_in_ship_to_org_tbl(l_index) = FND_API.g_FALSE AND
906: x_items.ship_to_org_id_tbl(l_index) IS NOT NULL AND
907: x_items.ship_to_org_id_tbl(l_index) <> PO_PDOI_PARAMS.g_sys.master_inv_org_id AND
908: x_items.ship_to_org_id_tbl(l_index) <> PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN
909: x_create_in_ship_to_index_tbl(l_index) := l_index;
910: END IF;
911: ELSIF (x_items.ln_item_id_tbl(l_index) IS NOT NULL) THEN
912: -- for each po line, if item_id is not empty, then update item in item master

Line 1115: DECODE(p_org_type, 'MASTER', PO_PDOI_PARAMS.g_sys.master_inv_org_id,

1111: x_items.request_id_tbl(i),
1112: x_items.program_application_id_tbl(i),
1113: x_items.program_id_tbl(i),
1114: x_items.program_update_date_tbl(i),
1115: DECODE(p_org_type, 'MASTER', PO_PDOI_PARAMS.g_sys.master_inv_org_id,
1116: 'INV', PO_PDOI_PARAMS.g_sys.def_inv_org_id,
1117: x_items.ship_to_org_id_tbl(i)), -- organization_id
1118: x_items.ln_item_attribute_category_tbl(i),
1119: x_items.ln_item_attribute1_tbl(i),

Line 1116: 'INV', PO_PDOI_PARAMS.g_sys.def_inv_org_id,

1112: x_items.program_application_id_tbl(i),
1113: x_items.program_id_tbl(i),
1114: x_items.program_update_date_tbl(i),
1115: DECODE(p_org_type, 'MASTER', PO_PDOI_PARAMS.g_sys.master_inv_org_id,
1116: 'INV', PO_PDOI_PARAMS.g_sys.def_inv_org_id,
1117: x_items.ship_to_org_id_tbl(i)), -- organization_id
1118: x_items.ln_item_attribute_category_tbl(i),
1119: x_items.ln_item_attribute1_tbl(i),
1120: x_items.ln_item_attribute2_tbl(i),

Line 1148: l_org_id := PO_PDOI_PARAMS.g_sys.master_inv_org_id;

1144: l_index := p_index_tbl.FIRST;
1145: WHILE (l_index IS NOT NULL)
1146: LOOP
1147: IF (p_org_type = 'MASTER') THEN
1148: l_org_id := PO_PDOI_PARAMS.g_sys.master_inv_org_id;
1149: ELSIF (p_org_type = 'INV') THEN
1150: l_org_id := PO_PDOI_PARAMS.g_sys.def_inv_org_id;
1151: ELSE
1152: l_org_id := x_items.ship_to_org_id_tbl(l_index);

Line 1150: l_org_id := PO_PDOI_PARAMS.g_sys.def_inv_org_id;

1146: LOOP
1147: IF (p_org_type = 'MASTER') THEN
1148: l_org_id := PO_PDOI_PARAMS.g_sys.master_inv_org_id;
1149: ELSIF (p_org_type = 'INV') THEN
1150: l_org_id := PO_PDOI_PARAMS.g_sys.def_inv_org_id;
1151: ELSE
1152: l_org_id := x_items.ship_to_org_id_tbl(l_index);
1153: END IF;
1154:

Line 1264: AND category_set_id = PO_PDOI_PARAMS.g_sys.def_cat_set_id;

1260: UPDATE mtl_item_categories
1261: SET category_id = l_category_id_tbl(i)
1262: WHERE inventory_item_id = l_item_id_tbl(i)
1263: AND organization_id = l_org_id_tbl(i)
1264: AND category_set_id = PO_PDOI_PARAMS.g_sys.def_cat_set_id;
1265:
1266: d_position := 60;
1267:
1268: -- delete rows from item interface tables

Line 1440: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

1436: description,
1437: list_price_per_unit
1438: FROM mtl_system_items
1439: WHERE inventory_item_id = x_items.ln_item_id_tbl(i)
1440: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
1441:
1442: d_position := 10;
1443:
1444: DELETE FROM po_session_gt

Line 1503: p_Organization_Id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,

1499: p_init_msg_list => FND_API.g_TRUE,
1500: p_commit => FND_API.g_TRUE,
1501: p_Transaction_Type => 'UPDATE',
1502: p_Inventory_Item_Id => x_items.ln_item_id_tbl(l_index),
1503: p_Organization_Id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
1504: p_description => NVL(x_items.ln_item_desc_tbl(l_index), EGO_ITEM_PUB.G_MISS_CHAR),
1505: p_list_price_per_unit => NVL(x_items.ln_list_price_per_unit_tbl(l_index), EGO_ITEM_PUB.G_MISS_NUM),
1506: p_Item_Number => x_items.ln_item_tbl(l_index),
1507: x_Inventory_Item_Id => l_inventory_item_id,