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 825: (PO_PDOI_PARAMS.g_sys.def_inv_org_id,

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

Line 826: PO_PDOI_PARAMS.g_sys.master_inv_org_id,

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

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

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

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

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

Line 897: PO_PDOI_PARAMS.g_sys.master_inv_org_id <>

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

Line 898: PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1505: p_init_msg_list => FND_API.g_TRUE,
1506: p_commit => FND_API.g_TRUE,
1507: p_Transaction_Type => 'UPDATE',
1508: p_Inventory_Item_Id => x_items.ln_item_id_tbl(l_index),
1509: p_Organization_Id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
1510: p_description => NVL(x_items.ln_item_desc_tbl(l_index), EGO_ITEM_PUB.G_MISS_CHAR),
1511: p_list_price_per_unit => NVL(x_items.ln_list_price_per_unit_tbl(l_index), EGO_ITEM_PUB.G_MISS_NUM),
1512: p_Item_Number => x_items.ln_item_tbl(l_index),
1513: x_Inventory_Item_Id => l_inventory_item_id,