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_TLP_INTERFACE

Line 75: action po_attr_values_tlp_interface.action%TYPE,

71: TYPE g_po_attrvalstlp_int_rec_type IS RECORD
72: (
73: interface_header_id NUMBER,
74: interface_line_id NUMBER,
75: action po_attr_values_tlp_interface.action%TYPE,
76: po_line_id NUMBER,
77: req_template_name po_attr_values_tlp_interface.req_template_name%TYPE,
78: req_template_line_num NUMBER,
79: inventory_item_id NUMBER,

Line 77: req_template_name po_attr_values_tlp_interface.req_template_name%TYPE,

73: interface_header_id NUMBER,
74: interface_line_id NUMBER,
75: action po_attr_values_tlp_interface.action%TYPE,
76: po_line_id NUMBER,
77: req_template_name po_attr_values_tlp_interface.req_template_name%TYPE,
78: req_template_line_num NUMBER,
79: inventory_item_id NUMBER,
80: org_id NUMBER,
81: language po_attr_values_tlp_interface.language%TYPE,

Line 81: language po_attr_values_tlp_interface.language%TYPE,

77: req_template_name po_attr_values_tlp_interface.req_template_name%TYPE,
78: req_template_line_num NUMBER,
79: inventory_item_id NUMBER,
80: org_id NUMBER,
81: language po_attr_values_tlp_interface.language%TYPE,
82: check_desc_update VARCHAR2(25),
83: rt_item_id NUMBER
84: );
85:

Line 172: --INSERT po_attr_values_tlp_interface

168: gIAVOrgIdTbl DBMS_SQL.NUMBER_TABLE;
169: gIAVRtItemIdTbl DBMS_SQL.NUMBER_TABLE;
170: gIAVLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
171:
172: --INSERT po_attr_values_tlp_interface
173: gIAVTInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
174: gIAVTInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
175: gIAVTActionTbl DBMS_SQL.VARCHAR2_TABLE;
176: gIAVTPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 288: --INSERT po_attr_values_tlp_interface

284: gIAVLanguageTbl.DELETE;
285: END IF;
286:
287: IF (p_action_mode IN ('ALL', 'INSERT_INT_ATTR_VALS_TLP')) THEN
288: --INSERT po_attr_values_tlp_interface
289: gIAVTInterfaceHeaderIdTbl.DELETE;
290: gIAVTInterfaceLineIdTbl.DELETE;
291: gIAVTActionTbl.DELETE;
292: gIAVTPoLineIdTbl.DELETE;

Line 458: --INSERT po_attr_values_tlp_interface

454: ICX_CAT_UTIL_PVT.getTableElement(gIAVLanguageTbl, p_index) || ', ';
455: END IF;
456:
457: IF (p_action_mode = 'INSERT_INT_ATTR_VALS_TLP') THEN
458: --INSERT po_attr_values_tlp_interface
459: l_string := l_string || ' gIAVTInterfaceHeaderIdTbl: ' ||
460: ICX_CAT_UTIL_PVT.getTableElement(gIAVTInterfaceHeaderIdTbl, p_index) || ', ';
461: l_string := l_string || ' gIAVTInterfaceLineIdTbl: ' ||
462: ICX_CAT_UTIL_PVT.getTableElement(gIAVTInterfaceLineIdTbl, p_index) || ', ';

Line 779: -- INSERT po_attr_values_tlp_interface

775: l_err_loc := 1000;
776:
777: IF (p_action_mode = 'INSERT_INT_ATTR_VALS_TLP') THEN
778: l_err_loc := 1100;
779: -- INSERT po_attr_values_tlp_interface
780: l_log_string := ' gIAVTInterfaceHeaderIdTbl: ' ||
781: ICX_CAT_UTIL_PVT.getTableElement(gIAVTInterfaceHeaderIdTbl, p_index) || '; ';
782: FND_LOG.string(p_log_level, l_module_name, l_log_string);
783:

Line 1091: l_action po_attr_values_tlp_interface.action%TYPE;

1087: )
1088: RETURN VARCHAR2
1089: IS
1090:
1091: l_action po_attr_values_tlp_interface.action%TYPE;
1092: l_api_name CONSTANT VARCHAR2(30) := 'getPOAttrValuesTLPAction';
1093: l_err_loc PLS_INTEGER;
1094: BEGIN
1095: l_err_loc := 100;

Line 1680: INSERT INTO po_attr_values_tlp_interface

1676:
1677: l_err_loc := 230;
1678: l_action_mode := 'INSERT_INT_ATTR_VALS_TLP';
1679: FORALL i in 1..gIAVTInterfaceHeaderIdTbl.COUNT
1680: INSERT INTO po_attr_values_tlp_interface
1681: (interface_attr_values_tlp_id, interface_header_id,
1682: interface_line_id, action, process_code,
1683: po_line_id, req_template_name, req_template_line_num,
1684: inventory_item_id, org_id, language,

Line 1737: SELECT po_attr_values_tlp_interface_s.NEXTVAL, gIAVTInterfaceHeaderIdTbl(i),

1733: tl_text_cat_attribute39, tl_text_cat_attribute40, tl_text_cat_attribute41,
1734: tl_text_cat_attribute42, tl_text_cat_attribute43, tl_text_cat_attribute44,
1735: tl_text_cat_attribute45, tl_text_cat_attribute46, tl_text_cat_attribute47,
1736: tl_text_cat_attribute48, tl_text_cat_attribute49, tl_text_cat_attribute50)
1737: SELECT po_attr_values_tlp_interface_s.NEXTVAL, gIAVTInterfaceHeaderIdTbl(i),
1738: gIAVTInterfaceLineIdTbl(i), gIAVTActionTbl(i), g_process_code,
1739: gIAVTPoLineIdTbl(i), gIAVTReqTemplateNameTbl(i), gIAVTReqTemplateLineNumTbl(i),
1740: gIAVTInventoryItemIdTbl(i), gIAVTOrgIdTbl(i), gIAVTLanguageTbl(i), baseAtt.primary_category_id,
1741: -- DECODE(gIAVTCheckDescUpdateTbl(i), ICX_CAT_UTIL_PVT.g_update_description, SUBSTRB(baseAtt.description, 1, 240), NULL),

Line 1805: 'No: of rows inserted into po_attr_values_tlp_interface:' ||SQL%ROWCOUNT);

1801: IF (gIAVTInterfaceHeaderIdTbl.COUNT > 0) THEN
1802: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1803: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1804: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1805: 'No: of rows inserted into po_attr_values_tlp_interface:' ||SQL%ROWCOUNT);
1806: END IF;
1807: END IF;
1808:
1809: l_err_loc := 250;

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 3544: -- po_attr_values_tlp_interface

3540: g_po_line_attrval_int_rec.language := g_current_gbpa_hdr_rec.language;
3541:
3542: l_err_loc := 282;
3543: -- Put the current values into g_po_attrvalstlp_int_rec for
3544: -- po_attr_values_tlp_interface
3545: g_po_attrvalstlp_int_rec.interface_header_id := l_interface_header_id;
3546: g_po_attrvalstlp_int_rec.interface_line_id := l_interface_line_id;
3547:
3548: l_err_loc := 284;

Line 3590: --po_attr_values_tlp_interface

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) ;
3593: g_po_attrvalstlp_int_rec.interface_line_id := l_po_interface_line_id_tbl(i);
3594: END IF;

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 3935: --po_attr_values_tlp_interface

3931: g_po_line_attrval_int_rec.language := g_current_gbpa_hdr_rec.language;
3932:
3933: l_err_loc := 240;
3934: --Put the current values into g_po_attrvalstlp_int_rec for
3935: --po_attr_values_tlp_interface
3936: g_po_attrvalstlp_int_rec.interface_header_id := g_current_gbpa_hdr_rec.interface_header_id ;
3937: g_po_attrvalstlp_int_rec.interface_line_id := l_interface_line_id;
3938: g_po_attrvalstlp_int_rec.action := 'ADD';
3939: g_po_attrvalstlp_int_rec.po_line_id := null;

Line 4640: -- and po_attr_values_tlp_interface

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
4644: --Create the header record only once for the

Line 4854: -- (so only need to insert into po_attr_values_tlp_interface)

4850: ELSE
4851: -- g_current_gbpa_hdr_rec.interface_header_id <> l_po_interface_header_id_tbl(i)
4852: -- possible case:
4853: -- The lines in this cursor are translations of the earlier header lines
4854: -- (so only need to insert into po_attr_values_tlp_interface)
4855: -- l_dml_reqd_in_lines := FALSE;
4856: -- IF po_header_id is not null and created_language = the current row language, then
4857: -- insert into lines are attr values tables.
4858: l_dml_reqd_in_r12Upgrade := FALSE;

Line 4907: -- So that the po_line_id is null in po_attr_values_tlp_interface

4903: insertR12Upgrade;
4904: ELSE
4905: l_err_loc := 252;
4906: IF (l_line_deleted) THEN
4907: -- So that the po_line_id is null in po_attr_values_tlp_interface
4908: -- when translation is inserted for a deleted line
4909: -- (Note: the line was deleted due to source / category change)
4910: g_r12_upg_rec.po_line_id := null;
4911: g_r12_upg_rec.po_header_id := null;

Line 5001: -- Always need to insert into po_attr_values_tlp_interface

4997: l_err_loc := 274;
4998: insertPOAttrValsInterface;
4999: END IF; -- IF (l_dml_reqd_in_lines)
5000:
5001: -- Always need to insert into po_attr_values_tlp_interface
5002: -- Put the current values into g_po_attrvalstlp_int_rec for
5003: -- po_attr_values_tlp_interface
5004: l_err_loc := 276;
5005: g_po_attrvalstlp_int_rec.interface_header_id := l_interface_header_id;

Line 5003: -- po_attr_values_tlp_interface

4999: END IF; -- IF (l_dml_reqd_in_lines)
5000:
5001: -- Always need to insert into po_attr_values_tlp_interface
5002: -- Put the current values into g_po_attrvalstlp_int_rec for
5003: -- po_attr_values_tlp_interface
5004: l_err_loc := 276;
5005: g_po_attrvalstlp_int_rec.interface_header_id := l_interface_header_id;
5006: g_po_attrvalstlp_int_rec.interface_line_id := l_interface_line_id;
5007: l_err_loc := 278;