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_LINES_INTERFACE

Line 50: action po_lines_interface.action%TYPE,

46: TYPE g_po_line_attrval_int_rec_type IS RECORD
47: (
48: interface_line_id NUMBER,
49: interface_header_id NUMBER,
50: action po_lines_interface.action%TYPE,
51: po_line_id NUMBER,
52: po_header_id NUMBER,
53: unit_price NUMBER,
54: uom_code po_lines_interface.uom_code%TYPE,

Line 54: uom_code po_lines_interface.uom_code%TYPE,

50: action po_lines_interface.action%TYPE,
51: po_line_id NUMBER,
52: po_header_id NUMBER,
53: unit_price NUMBER,
54: uom_code po_lines_interface.uom_code%TYPE,
55: negotiated_by_preparer_flag po_lines_interface.negotiated_by_preparer_flag%TYPE,
56: ip_category_id NUMBER,
57: category_id NUMBER,
58: category_name po_lines_interface.category%TYPE,

Line 55: negotiated_by_preparer_flag po_lines_interface.negotiated_by_preparer_flag%TYPE,

51: po_line_id NUMBER,
52: po_header_id NUMBER,
53: unit_price NUMBER,
54: uom_code po_lines_interface.uom_code%TYPE,
55: negotiated_by_preparer_flag po_lines_interface.negotiated_by_preparer_flag%TYPE,
56: ip_category_id NUMBER,
57: category_id NUMBER,
58: category_name po_lines_interface.category%TYPE,
59: vendor_product_num po_lines_interface.vendor_product_num%TYPE,

Line 58: category_name po_lines_interface.category%TYPE,

54: uom_code po_lines_interface.uom_code%TYPE,
55: negotiated_by_preparer_flag po_lines_interface.negotiated_by_preparer_flag%TYPE,
56: ip_category_id NUMBER,
57: category_id NUMBER,
58: category_name po_lines_interface.category%TYPE,
59: vendor_product_num po_lines_interface.vendor_product_num%TYPE,
60: supplier_part_auxid po_lines_interface.supplier_part_auxid%TYPE,
61: item_description po_lines_interface.item_description%TYPE,
62: catalog_name po_lines_interface.catalog_name%TYPE,

Line 59: vendor_product_num po_lines_interface.vendor_product_num%TYPE,

55: negotiated_by_preparer_flag po_lines_interface.negotiated_by_preparer_flag%TYPE,
56: ip_category_id NUMBER,
57: category_id NUMBER,
58: category_name po_lines_interface.category%TYPE,
59: vendor_product_num po_lines_interface.vendor_product_num%TYPE,
60: supplier_part_auxid po_lines_interface.supplier_part_auxid%TYPE,
61: item_description po_lines_interface.item_description%TYPE,
62: catalog_name po_lines_interface.catalog_name%TYPE,
63: req_template_name icx_cat_item_prices.template_id%TYPE,

Line 60: supplier_part_auxid po_lines_interface.supplier_part_auxid%TYPE,

56: ip_category_id NUMBER,
57: category_id NUMBER,
58: category_name po_lines_interface.category%TYPE,
59: vendor_product_num po_lines_interface.vendor_product_num%TYPE,
60: supplier_part_auxid po_lines_interface.supplier_part_auxid%TYPE,
61: item_description po_lines_interface.item_description%TYPE,
62: catalog_name po_lines_interface.catalog_name%TYPE,
63: req_template_name icx_cat_item_prices.template_id%TYPE,
64: req_template_line_num NUMBER,

Line 61: item_description po_lines_interface.item_description%TYPE,

57: category_id NUMBER,
58: category_name po_lines_interface.category%TYPE,
59: vendor_product_num po_lines_interface.vendor_product_num%TYPE,
60: supplier_part_auxid po_lines_interface.supplier_part_auxid%TYPE,
61: item_description po_lines_interface.item_description%TYPE,
62: catalog_name po_lines_interface.catalog_name%TYPE,
63: req_template_name icx_cat_item_prices.template_id%TYPE,
64: req_template_line_num NUMBER,
65: inventory_item_id NUMBER,

Line 62: catalog_name po_lines_interface.catalog_name%TYPE,

58: category_name po_lines_interface.category%TYPE,
59: vendor_product_num po_lines_interface.vendor_product_num%TYPE,
60: supplier_part_auxid po_lines_interface.supplier_part_auxid%TYPE,
61: item_description po_lines_interface.item_description%TYPE,
62: catalog_name po_lines_interface.catalog_name%TYPE,
63: req_template_name icx_cat_item_prices.template_id%TYPE,
64: req_template_line_num NUMBER,
65: inventory_item_id NUMBER,
66: org_id NUMBER,

Line 143: --INSERT po_lines_interface

139: gIHCpaReferenceTbl DBMS_SQL.NUMBER_TABLE;
140: gIHCreatedLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
141: gIHCommentsTbl DBMS_SQL.VARCHAR2_TABLE;
142:
143: --INSERT po_lines_interface
144: gILInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
145: gILInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
146: gILActionTbl DBMS_SQL.VARCHAR2_TABLE;
147: gILPoLineIdTbl DBMS_SQL.NUMBER_TABLE;

Line 255: --INSERT po_lines_interface

251: gIHCommentsTbl.DELETE;
252: END IF;
253:
254: IF (p_action_mode IN ('ALL', 'INSERT_INT_LINES')) THEN
255: --INSERT po_lines_interface
256: gILInterfaceLineIdTbl.DELETE;
257: gILInterfaceHeaderIdTbl.DELETE;
258: gILActionTbl.DELETE;
259: gILPoLineIdTbl.DELETE;

Line 399: --INSERT po_lines_interface

395: ICX_CAT_UTIL_PVT.getTableElement(gIHCommentsTbl, p_index) || ', ';
396: END IF;
397:
398: IF (p_action_mode = 'INSERT_INT_LINES') THEN
399: --INSERT po_lines_interface
400: l_string := l_string || ' gILInterfaceLineIdTbl: ' ||
401: ICX_CAT_UTIL_PVT.getTableElement(gILInterfaceLineIdTbl, p_index) || ', ';
402: l_string := l_string || ' gILInterfaceHeaderIdTbl: ' ||
403: ICX_CAT_UTIL_PVT.getTableElement(gILInterfaceHeaderIdTbl, p_index) || ', ';

Line 665: -- INSERT po_lines_interface

661: l_err_loc := 600;
662:
663: IF (p_action_mode = 'INSERT_INT_LINES') THEN
664: l_err_loc := 700;
665: -- INSERT po_lines_interface
666: l_log_string := ' gILInterfaceLineIdTbl: ' ||
667: ICX_CAT_UTIL_PVT.getTableElement(gILInterfaceLineIdTbl, p_index) || '; ';
668: FND_LOG.string(p_log_level, l_module_name, l_log_string);
669:

Line 1044: SELECT po_lines_interface_s.NEXTVAL

1040: l_api_name CONSTANT VARCHAR2(30) := 'getNextInterfaceLineIdFromSeq';
1041: l_err_loc PLS_INTEGER;
1042: BEGIN
1043: l_err_loc := 100;
1044: SELECT po_lines_interface_s.NEXTVAL
1045: INTO l_interface_line_id
1046: FROM DUAL;
1047:
1048: l_err_loc := 110;

Line 1419: INSERT INTO po_lines_interface

1415:
1416: l_err_loc := 170;
1417: l_action_mode := 'INSERT_INT_LINES';
1418: FORALL i in 1..gILInterfaceHeaderIdTbl.COUNT
1419: INSERT INTO po_lines_interface
1420: (interface_line_id, interface_header_id, process_code, action,
1421: po_line_id, po_header_id, unit_price,
1422: uom_code, negotiated_by_preparer_flag, ip_category_id, category_id, category,
1423: vendor_product_num, supplier_part_auxid, item_description, catalog_name)

Line 1434: 'No: of rows inserted into po_lines_interface:' ||SQL%ROWCOUNT);

1430: IF (gILInterfaceHeaderIdTbl.COUNT > 0) THEN
1431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1433: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1434: 'No: of rows inserted into po_lines_interface:' ||SQL%ROWCOUNT);
1435: END IF;
1436: END IF;
1437:
1438: l_err_loc := 190;

Line 2809: --The following will be null in po_lines_interface

2805: g_po_line_attrval_int_rec.language := l_language_tbl(i);
2806: g_po_line_attrval_int_rec.supplier_part_auxid := l_supplier_part_auxid_tbl(i);
2807: g_po_line_attrval_int_rec.catalog_name := l_catalog_name_tbl(i);
2808: g_po_line_attrval_int_rec.ip_category_id := l_primary_category_id_tbl(i);
2809: --The following will be null in po_lines_interface
2810: --when moving item attributes for req templates
2811: g_po_line_attrval_int_rec.po_header_id := null;
2812: g_po_line_attrval_int_rec.unit_price := null;
2813: g_po_line_attrval_int_rec.uom_code := null;

Line 2922: -- and dummy lines in po_lines interface for each line in a requisition template (express_name).

2918: -- Populate po headers, lines, attributes and attributes_tlp interface tables.
2919: --2. Process Requisition templates:
2920: -- populate po attributes and attributes_tlp interface tables
2921: -- and dummy lines in po headers interface for each express_name and org_id
2922: -- and dummy lines in po_lines interface for each line in a requisition template (express_name).
2923: processBlanketsAndQuotes;
2924:
2925: l_err_loc := 200;
2926: processReqTemplates;

Line 3505: --Get the next interfaceLineId to be used in po_lines_interface,

3501: insertPOHeadersInterface;
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;

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 3897: --Get the next interfaceLineId to be used in po_lines_interface,

3893: ', l_price_type_tbl:' || l_price_type_tbl(i) );
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;

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 4793: --Put the current values into g_po_line_attrval_int_rec for po_lines_interface

4789: END IF; -- IF (l_del_interface_header_id IS NULL)
4790:
4791: l_del_interface_line_id := getNextInterfaceLineIdFromSeq;
4792: l_err_loc := 238;
4793: --Put the current values into g_po_line_attrval_int_rec for po_lines_interface
4794: g_po_line_attrval_int_rec.interface_header_id := l_del_interface_header_id;
4795: g_po_line_attrval_int_rec.interface_line_id := l_del_interface_line_id;
4796: g_po_line_attrval_int_rec.action := 'DELETE';
4797: g_po_line_attrval_int_rec.po_line_id := l_po_line_id_tbl(i);

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';

Line 5467: --in po_lines_interface with DELETE action

5463: END IF;
5464:
5465: IF (l_po_line_id_tbl(i) IS NOT NULL) THEN
5466: --Only if the line was created as a po_line, need to Insert a row
5467: --in po_lines_interface with DELETE action
5468: --And also delete the row from icx_cat_r12_upgrade.
5469: IF (l_prev_po_header_id <> l_po_header_id_tbl(i)) THEN
5470: --po_header_id has changed, so get the next interfaceHeaderId
5471: --and populate a line in po_headers_interface

Line 5501: --Get the next interfaceLineId to be used in po_lines_interface

5497: END IF;
5498: insertPOHeadersInterface;
5499: END IF;
5500:
5501: --Get the next interfaceLineId to be used in po_lines_interface
5502: l_interface_line_id := getNextInterfaceLineIdFromSeq;
5503: l_err_loc := 220;
5504: --Put the current values into g_po_line_attrval_int_rec for po_lines_interface
5505: g_po_line_attrval_int_rec.interface_header_id := l_interface_header_id;

Line 5504: --Put the current values into g_po_line_attrval_int_rec for po_lines_interface

5500:
5501: --Get the next interfaceLineId to be used in po_lines_interface
5502: l_interface_line_id := getNextInterfaceLineIdFromSeq;
5503: l_err_loc := 220;
5504: --Put the current values into g_po_line_attrval_int_rec for po_lines_interface
5505: g_po_line_attrval_int_rec.interface_header_id := l_interface_header_id;
5506: g_po_line_attrval_int_rec.interface_line_id := l_interface_line_id;
5507: g_po_line_attrval_int_rec.action := 'DELETE';
5508: g_po_line_attrval_int_rec.po_line_id := l_po_line_id_tbl(i);

Line 6186: FROM po_lines_interface pli

6182: FORALL i IN 1..p_interface_line_id.COUNT
6183: UPDATE icx_cat_r12_upgrade upg
6184: SET po_line_id =
6185: (SELECT po_line_id
6186: FROM po_lines_interface pli
6187: WHERE pli.interface_line_id = upg.po_interface_line_id)
6188: WHERE upg.po_interface_line_id = p_interface_line_id(i);
6189:
6190: l_err_loc := 300;