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_UTILITY_GRP dependencies on CSI_DATASTRUCTURES_PUB

Line 421: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

417: l_item_id number;
418:
419: BEGIN
420:
421: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
422: csi_gen_utility_pvt.populate_install_param_rec;
423: END IF;
424:
425: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NULL then

Line 425: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NULL then

421: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
422: csi_gen_utility_pvt.populate_install_param_rec;
423: END IF;
424:
425: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NULL then
426: SELECT freeze_date
427: INTO l_freeze_date
428: FROM csi_install_parameters
429: WHERE rownum = 1;

Line 431: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

427: INTO l_freeze_date
428: FROM csi_install_parameters
429: WHERE rownum = 1;
430: ELSE
431: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
432: END IF;
433:
434: FOR msg_rec in msg_cur (l_freeze_date)
435: LOOP

Line 960: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

956: x_msg_data OUT NOCOPY VARCHAR2) IS
957:
958:
959: l_api_name CONSTANT VARCHAR2(30) := 'GET_INSTANCES';
960: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
961: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
962: l_depth NUMBER;
963: l_active_relationship_only VARCHAR2(1);
964: l_active_instances_only VARCHAR2(1);

Line 961: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

957:
958:
959: l_api_name CONSTANT VARCHAR2(30) := 'GET_INSTANCES';
960: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
961: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
962: l_depth NUMBER;
963: l_active_relationship_only VARCHAR2(1);
964: l_active_instances_only VARCHAR2(1);
965: l_config_only VARCHAR2(1); -- if true will retrieve instances with config keys

Line 1390: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

1386:
1387: -- Check for the Freeze Date Existance and If there is a data is that
1388: -- before the freeze date.
1389:
1390: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1391: csi_gen_utility_pvt.populate_install_param_rec;
1392: END IF;
1393:
1394: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NULL then

Line 1394: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NULL then

1390: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1391: csi_gen_utility_pvt.populate_install_param_rec;
1392: END IF;
1393:
1394: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NULL then
1395: raise inv_purge_allowed;
1396: ELSE
1397: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
1398: END IF;

Line 1397: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

1393:
1394: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NULL then
1395: raise inv_purge_allowed;
1396: ELSE
1397: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
1398: END IF;
1399:
1400: IF l_freeze_date > l_transaction_date_tab(ind) THEN
1401: RAISE inv_purge_allowed;

Line 1495: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

1491:
1492: -- Check for the Freeze Date Existance and If there is a data is that
1493: -- before the freeze date.
1494:
1495: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1496: csi_gen_utility_pvt.populate_install_param_rec;
1497: END IF;
1498:
1499: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NOT NULL then

Line 1499: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NOT NULL then

1495: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1496: csi_gen_utility_pvt.populate_install_param_rec;
1497: END IF;
1498:
1499: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NOT NULL then
1500: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
1501: ELSE
1502: l_freeze_date := p_om_txn_info(j).request_date + 1;
1503: END IF;

Line 1500: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

1496: csi_gen_utility_pvt.populate_install_param_rec;
1497: END IF;
1498:
1499: IF csi_datastructures_pub.g_install_param_rec.freeze_date is NOT NULL then
1500: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
1501: ELSE
1502: l_freeze_date := p_om_txn_info(j).request_date + 1;
1503: END IF;
1504: