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.ICX_CAT_R12_UPGRADE_PVT dependencies on PO_ATTR_VALUES_INTERFACE

Line 160: --INSERT po_attr_values_interface

156: gILSupplierPartAuxidTbl DBMS_SQL.VARCHAR2_TABLE;
157: gILItemDescripionTbl DBMS_SQL.VARCHAR2_TABLE;
158: gILCatalogNameTbl DBMS_SQL.VARCHAR2_TABLE;
159:
160: --INSERT po_attr_values_interface
161: gIAVInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
162: gIAVInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
163: gIAVActionTbl DBMS_SQL.VARCHAR2_TABLE;
164: gIAVPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 274: --INSERT po_attr_values_interface

270: gILCatalogNameTbl.DELETE;
271: END IF;
272:
273: IF (p_action_mode IN ('ALL', 'INSERT_INT_ATTR_VALS')) THEN
274: --INSERT po_attr_values_interface
275: gIAVInterfaceHeaderIdTbl.DELETE;
276: gIAVInterfaceLineIdTbl.DELETE;
277: gIAVActionTbl.DELETE;
278: gIAVPoLineIdTbl.DELETE;

Line 434: --INSERT po_attr_values_interface

430:
431: END IF;
432:
433: IF (p_action_mode = 'INSERT_INT_ATTR_VALS') THEN
434: --INSERT po_attr_values_interface
435: l_string := l_string || ' gIAVInterfaceHeaderIdTbl: ' ||
436: ICX_CAT_UTIL_PVT.getTableElement(gIAVInterfaceHeaderIdTbl, p_index) || ', ';
437: l_string := l_string || ' gIAVInterfaceLineIdTbl: ' ||
438: ICX_CAT_UTIL_PVT.getTableElement(gIAVInterfaceLineIdTbl, p_index) || ', ';

Line 732: -- INSERT po_attr_values_interface

728: l_err_loc := 800;
729:
730: IF (p_action_mode = 'INSERT_INT_ATTR_VALS') THEN
731: l_err_loc := 900;
732: -- INSERT po_attr_values_interface
733: l_log_string := ' gIAVInterfaceHeaderIdTbl: ' ||
734: ICX_CAT_UTIL_PVT.getTableElement(gIAVInterfaceHeaderIdTbl, p_index) || '; ';
735: FND_LOG.string(p_log_level, l_module_name, l_log_string);
736:

Line 1444: INSERT INTO po_attr_values_interface

1440:
1441: l_err_loc := 200;
1442: l_action_mode := 'INSERT_INT_ATTR_VALS';
1443: FORALL i in 1..gIAVInterfaceHeaderIdTbl.COUNT
1444: INSERT INTO po_attr_values_interface
1445: (interface_attr_values_id, interface_header_id,
1446: interface_line_id, process_code, action,
1447: po_line_id, req_template_name, req_template_line_num,
1448: inventory_item_id, org_id,

Line 1552: SELECT po_attr_values_interface_s.NEXTVAL, gIAVInterfaceHeaderIdTbl(i),

1548: num_cat_attribute39, num_cat_attribute40, num_cat_attribute41,
1549: num_cat_attribute42, num_cat_attribute43, num_cat_attribute44,
1550: num_cat_attribute45, num_cat_attribute46, num_cat_attribute47,
1551: num_cat_attribute48, num_cat_attribute49, num_cat_attribute50)
1552: SELECT po_attr_values_interface_s.NEXTVAL, gIAVInterfaceHeaderIdTbl(i),
1553: gIAVInterfaceLineIdTbl(i), g_process_code, gIAVActionTbl(i),
1554: gIAVPoLineIdTbl(i), gIAVReqTemplateNameTbl(i), gIAVReqTemplateLineNumTbl(i),
1555: gIAVInventoryItemIdTbl(i), gIAVOrgIdTbl(i),
1556: baseAtt.primary_category_id, baseAtt.manufacturer_part_num, baseAtt.thumbnail_image,

Line 1670: 'No: of rows inserted into po_attr_values_interface:' ||SQL%ROWCOUNT);

1666: IF (gIAVInterfaceHeaderIdTbl.COUNT > 0) THEN
1667: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1668: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1669: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1670: 'No: of rows inserted into po_attr_values_interface:' ||SQL%ROWCOUNT);
1671: END IF;
1672: END IF;
1673:
1674: l_err_loc := 220;

Line 3506: --po_attr_values_interface and po_attr_values_tlp_interface

3502: END IF;
3503:
3504: l_err_loc := 250;
3505: --Get the next interfaceLineId to be used in po_lines_interface,
3506: --po_attr_values_interface and po_attr_values_tlp_interface
3507: l_interface_line_id := getNextInterfaceLineIdFromSeq;
3508:
3509: l_err_loc := 260;
3510: l_po_category_id := TO_NUMBER(l_po_category_id_tbl(i));

Line 3514: --po_lines_interface and po_attr_values_interface

3510: l_po_category_id := TO_NUMBER(l_po_category_id_tbl(i));
3511:
3512: l_err_loc := 270;
3513: --Put the current values into g_po_line_attrval_int_rec for
3514: --po_lines_interface and po_attr_values_interface
3515: g_po_line_attrval_int_rec.interface_line_id := l_interface_line_id;
3516: g_po_line_attrval_int_rec.interface_header_id := l_interface_header_id;
3517: g_po_line_attrval_int_rec.action := 'ADD';
3518: g_po_line_attrval_int_rec.po_line_id := null;

Line 3588: --into po_lines_interface and po_attr_values_interface in processGBPALines

3584: ELSE --l_po_interface_header_id_tbl(i) IS NOT NULL
3585: --i.e. upg.rt_item_id = price.rt_item_id and
3586: --upg.created_language <> g_current_gbpa_hdr_rec.language
3587: --i.e. this is a translation row of an item already inserted
3588: --into po_lines_interface and po_attr_values_interface in processGBPALines
3589: --Put the current values into g_po_attrvalstlp_int_rec for it to be inserted into
3590: --po_attr_values_tlp_interface
3591: l_err_loc := 296;
3592: g_po_attrvalstlp_int_rec.interface_header_id := l_po_interface_header_id_tbl(i) ;

Line 3898: --po_attr_values_interface and po_attr_values_tlp_interface

3894: END IF;
3895:
3896: l_err_loc := 210;
3897: --Get the next interfaceLineId to be used in po_lines_interface,
3898: --po_attr_values_interface and po_attr_values_tlp_interface
3899: l_interface_line_id := getNextInterfaceLineIdFromSeq;
3900:
3901: l_err_loc := 220;
3902: l_po_category_id := TO_NUMBER(l_po_category_id_tbl(i));

Line 3906: --po_lines_interface and po_attr_values_interface

3902: l_po_category_id := TO_NUMBER(l_po_category_id_tbl(i));
3903:
3904: l_err_loc := 230;
3905: --Put the current values into g_po_line_attrval_int_rec for
3906: --po_lines_interface and po_attr_values_interface
3907: g_po_line_attrval_int_rec.interface_line_id := l_interface_line_id;
3908: g_po_line_attrval_int_rec.interface_header_id := g_current_gbpa_hdr_rec.interface_header_id ;
3909: g_po_line_attrval_int_rec.action := 'ADD';
3910: g_po_line_attrval_int_rec.po_line_id := null;

Line 4639: -- We need to insert rows in po_headers_interface, po_lines_interface, po_attr_values_interface

4635: l_po_interface_header_id_tbl(i) IS NOT NULL AND
4636: g_current_gbpa_hdr_rec.interface_header_id = l_po_interface_header_id_tbl(i)))
4637: THEN
4638: -- i.e. both the interface_header_id from the lines cursor and from the headers cursors are the same
4639: -- We need to insert rows in po_headers_interface, po_lines_interface, po_attr_values_interface
4640: -- and po_attr_values_tlp_interface
4641: -- IF interface_header_id from the headers cursor is null then insert into icx_cat_r12_upgrade table
4642: -- IF interface_header_id from the headers cursor is not null then update icx_cat_r12_upgrade table
4643: IF (l_firstRow) THEN

Line 4950: -- po_lines_interface and po_attr_values_interface

4946:
4947: IF (l_dml_reqd_in_lines) THEN
4948: l_err_loc := 260;
4949: -- Put the current values into g_po_line_attrval_int_rec for
4950: -- po_lines_interface and po_attr_values_interface
4951: g_po_line_attrval_int_rec.interface_line_id := l_interface_line_id;
4952: g_po_line_attrval_int_rec.interface_header_id := l_interface_header_id;
4953: IF (l_po_line_id_tbl(i) IS NULL OR l_line_deleted) THEN
4954: g_po_line_attrval_int_rec.action := 'ADD';