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.CSI_ML_UTIL_PVT dependencies on CSI_ML_UTIL_PVT

Line 1: PACKAGE BODY CSI_ML_UTIL_PVT AS

1: PACKAGE BODY CSI_ML_UTIL_PVT AS
2: -- $Header: csimutlb.pls 120.7 2007/10/31 00:49:13 anjgupta ship $
3:
4: PROCEDURE resolve_ids
5: ( p_txn_from_date IN VARCHAR2,

Line 105: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';

101: iea_intf_id_upd NumTabType;
102: asst_intf_id_upd NumTabType;
103: max_buffer_size NUMBER := 1000;
104:
105: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';
106: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
107: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
108: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
109: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

Line 630: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';

626: iea_intf_id_upd NumTabType;
627: asst_intf_id_upd NumTabType;
628: max_buffer_size NUMBER := 1000;
629:
630: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';
631: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
632: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
633: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
634: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

Line 1081: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_UPDATE_IDS';

1077: ip_intf_id_upd1 NumTabType;
1078: ip_intf_id_upd3 NumTabType;
1079: max_buffer_size NUMBER := 1000;
1080:
1081: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_UPDATE_IDS';
1082: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1083: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1084: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

Line 1467: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.LOG_CREATE_ERRORS';

1463: ORDER BY inst_interface_id;
1464:
1465: r_error c_error%rowtype;
1466:
1467: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.LOG_CREATE_ERRORS';
1468: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1469: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1470: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1471: l_sql_error VARCHAR2(2000);

Line 1519: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.LOG_CREATE_PW_ERRORS';

1515: ORDER BY inst_interface_id;
1516:
1517: r_error c_error%rowtype;
1518:
1519: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.LOG_CREATE_PW_ERRORS';
1520: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1521: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1522: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1523: l_sql_error VARCHAR2(2000);

Line 1559: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.SET_PTY_PROCESS_STATUS';

1555: x_return_status OUT NOCOPY VARCHAR2,
1556: x_error_message OUT NOCOPY VARCHAR2) IS
1557:
1558:
1559: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.SET_PTY_PROCESS_STATUS';
1560: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1561: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1562: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1563: l_sql_error VARCHAR2(2000);

Line 1587: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.SET_EXT_PROCESS_STATUS';

1583: x_return_status OUT NOCOPY VARCHAR2,
1584: x_error_message OUT NOCOPY VARCHAR2) IS
1585:
1586:
1587: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.SET_EXT_PROCESS_STATUS';
1588: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1589: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1590: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1591: l_sql_error VARCHAR2(2000);

Line 1623: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_REL_IDS';

1619: object_id_upd NumTabType;
1620: subject_id_upd NumTabType;
1621: max_buffer_size NUMBER := 1000;
1622:
1623: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_REL_IDS';
1624: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1625: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1626: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1627: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

Line 1678: p_rel_tbl OUT NOCOPY csi_ml_util_pvt.ii_rel_interface_tbl

1674: END resolve_rel_ids;
1675:
1676: PROCEDURE Get_Next_Level
1677: (p_object_id IN NUMBER,
1678: p_rel_tbl OUT NOCOPY csi_ml_util_pvt.ii_rel_interface_tbl
1679: ) IS
1680: --
1681: CURSOR REL_CUR IS
1682: SELECT rel_interface_id

Line 1705: p_rel_tbl OUT NOCOPY csi_ml_util_pvt.ii_rel_interface_tbl

1701:
1702:
1703: PROCEDURE Get_Children
1704: (p_object_id IN NUMBER,
1705: p_rel_tbl OUT NOCOPY csi_ml_util_pvt.ii_rel_interface_tbl
1706: ) IS
1707: --
1708: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;
1709: l_rel_tbl_next_lvl csi_ml_util_pvt.ii_rel_interface_tbl;

Line 1708: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;

1704: (p_object_id IN NUMBER,
1705: p_rel_tbl OUT NOCOPY csi_ml_util_pvt.ii_rel_interface_tbl
1706: ) IS
1707: --
1708: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;
1709: l_rel_tbl_next_lvl csi_ml_util_pvt.ii_rel_interface_tbl;
1710: l_rel_tbl_temp csi_ml_util_pvt.ii_rel_interface_tbl;
1711: l_rel_tbl_final csi_ml_util_pvt.ii_rel_interface_tbl;
1712: l_next_ind NUMBER := 0;

Line 1709: l_rel_tbl_next_lvl csi_ml_util_pvt.ii_rel_interface_tbl;

1705: p_rel_tbl OUT NOCOPY csi_ml_util_pvt.ii_rel_interface_tbl
1706: ) IS
1707: --
1708: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;
1709: l_rel_tbl_next_lvl csi_ml_util_pvt.ii_rel_interface_tbl;
1710: l_rel_tbl_temp csi_ml_util_pvt.ii_rel_interface_tbl;
1711: l_rel_tbl_final csi_ml_util_pvt.ii_rel_interface_tbl;
1712: l_next_ind NUMBER := 0;
1713: l_final_ind NUMBER := 0;

Line 1710: l_rel_tbl_temp csi_ml_util_pvt.ii_rel_interface_tbl;

1706: ) IS
1707: --
1708: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;
1709: l_rel_tbl_next_lvl csi_ml_util_pvt.ii_rel_interface_tbl;
1710: l_rel_tbl_temp csi_ml_util_pvt.ii_rel_interface_tbl;
1711: l_rel_tbl_final csi_ml_util_pvt.ii_rel_interface_tbl;
1712: l_next_ind NUMBER := 0;
1713: l_final_ind NUMBER := 0;
1714: l_ctr NUMBER := 0;

Line 1711: l_rel_tbl_final csi_ml_util_pvt.ii_rel_interface_tbl;

1707: --
1708: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;
1709: l_rel_tbl_next_lvl csi_ml_util_pvt.ii_rel_interface_tbl;
1710: l_rel_tbl_temp csi_ml_util_pvt.ii_rel_interface_tbl;
1711: l_rel_tbl_final csi_ml_util_pvt.ii_rel_interface_tbl;
1712: l_next_ind NUMBER := 0;
1713: l_final_ind NUMBER := 0;
1714: l_ctr NUMBER := 0;
1715: l_found NUMBER;

Line 1717: csi_ml_util_pvt.Get_Next_Level

1713: l_final_ind NUMBER := 0;
1714: l_ctr NUMBER := 0;
1715: l_found NUMBER;
1716: BEGIN
1717: csi_ml_util_pvt.Get_Next_Level
1718: ( p_object_id => p_object_id,
1719: p_rel_tbl => l_rel_tbl
1720: );
1721:

Line 1732: csi_ml_util_pvt.Get_Next_Level

1728: FOR l_ind IN l_rel_tbl.FIRST .. l_rel_tbl.LAST LOOP
1729: l_final_ind := l_final_ind + 1;
1730: l_rel_tbl_final(l_final_ind) := l_rel_tbl(l_ind);
1731: /* get the next level using this Subject ID as the parent */
1732: csi_ml_util_pvt.Get_Next_Level
1733: ( p_object_id => l_rel_tbl(l_ind).subject_id,
1734: p_rel_tbl => l_rel_tbl_temp
1735: );
1736: --

Line 1839: l_ii_relationship_rec_tab csi_ml_util_pvt.ii_relationship_rec_tab;

1835: l_party_tbl csi_datastructures_pub.party_tbl;
1836: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1837: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
1838: l_txn_rec csi_datastructures_pub.transaction_rec;
1839: l_ii_relationship_rec_tab csi_ml_util_pvt.ii_relationship_rec_tab;
1840: l_rel_hist_tbl csi_diagnostics_pkg.T_NUM;
1841: l_txn_id_tbl csi_diagnostics_pkg.T_NUM;
1842: l_config_root_tbl csi_diagnostics_pkg.T_NUM;
1843: l_msg_data VARCHAR2(2000);

Line 2392: csi_ml_util_pvt.Get_top_most_parent

2388: BEGIN
2389: l_iface_error_text := NULL;
2390: rel_row:=rel_row+1;
2391: FND_MSG_PUB.initialize;
2392: csi_ml_util_pvt.Get_top_most_parent
2393: ( p_subject_id => l_upd_ins_csr.subject_id
2394: ,p_rel_type_code => l_upd_ins_csr.relationship_type_code
2395: ,p_process_status => 'V'
2396: ,p_object_id => l_upd_obj_id

Line 2457: l_txn_rec.transaction_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');

2453: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.wip_job_id := '||l_instance_rec.wip_job_id);
2454: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.po_order_line_id := '||l_instance_rec.po_order_line_id);
2455: FND_File.Put_Line(Fnd_File.LOG,'Before update l_return_status := '||l_return_status);
2456: */
2457: l_txn_rec.transaction_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');
2458: l_txn_rec.transaction_date := sysdate;
2459: l_txn_rec.source_transaction_date := sysdate;
2460:
2461: csi_item_instance_pvt.update_item_instance

Line 2562: csi_ml_util_pvt.Get_top_most_parent

2558: l_iface_error_text := NULL;
2559: rel_row := rel_row+1;
2560: FND_MSG_PUB.initialize;
2561:
2562: csi_ml_util_pvt.Get_top_most_parent
2563: ( p_subject_id => l_re_upd_csr.subject_id
2564: ,p_rel_type_code => l_re_upd_csr.relationship_type_code
2565: ,p_process_status => 'U'
2566: ,p_object_id => l_upd_obj_id

Line 2611: l_txn_rec.transaction_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');

2607: WHERE instance_id = l_re_upd_csr.subject_id;
2608:
2609: l_return_status := FND_API.G_RET_STS_SUCCESS;
2610:
2611: l_txn_rec.transaction_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');
2612: l_txn_rec.transaction_date := sysdate;
2613: l_txn_rec.source_transaction_date := sysdate;
2614:
2615: csi_item_instance_pvt.update_item_instance

Line 2707: l_txn_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');

2703: FND_File.Put_Line(Fnd_File.LOG,'Inside for Insert mode');
2704: -- This run also has to insert records into csi_ii_relationships
2705: -- ,csi_ii_relationships_h and csi_transactions
2706: l_ins:=0;
2707: l_txn_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');
2708:
2709: FOR l_ins_rel_csr IN ins_rel_csr(p_worker_id, l_txn_from_date, l_txn_to_date)
2710: LOOP
2711: l_ins:=l_ins+1;

Line 3117: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;

3113: ,rel_interface_id
3114: ,relationship_type_code
3115: FROM csi_ii_relation_interface
3116: WHERE process_status='R';
3117: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;
3118: l_error BOOLEAN :=FALSE;
3119: l_rel_id_array dbms_sql.Number_Table;
3120: l_status_array dbms_sql.Varchar2_Table;
3121: l_error_array dbms_sql.Varchar2_Table;

Line 3131: csi_ml_util_pvt.get_children

3127: l_rel_tbl.DELETE;
3128: FOR l_chk_cyclic_csr IN chk_cyclic_csr
3129: LOOP
3130: l_error := FALSE;
3131: csi_ml_util_pvt.get_children
3132: (p_object_id => l_chk_cyclic_csr.subject_id,
3133: p_rel_tbl => l_rel_tbl
3134: );
3135:

Line 3184: END CSI_ML_UTIL_PVT;

3180: END LOOP;
3181: END check_cyclic;
3182: -- End check cyclic
3183:
3184: END CSI_ML_UTIL_PVT;