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

Line 126: (p_ext_attrib_values_rec IN csi_datastructures_pub.extend_attrib_values_rec)

122: RETURN null;
123: END dump_error_stack;
124:
125: PROCEDURE dump_ext_attrib_values_rec
126: (p_ext_attrib_values_rec IN csi_datastructures_pub.extend_attrib_values_rec)
127: IS
128: l_api_name CONSTANT VARCHAR2(30) := 'dump_ext_attrib_values_rec';
129: l_api_version CONSTANT NUMBER := 1.0;
130: BEGIN

Line 180: (p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl)

176: END dump_ext_attrib_values_rec;
177:
178:
179: PROCEDURE dump_ext_attrib_values_tbl
180: (p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl)
181: IS
182: l_api_name CONSTANT VARCHAR2(30) := 'dump_ext_attrib_values_tbl';
183: l_api_version CONSTANT NUMBER := 1.0;
184: BEGIN

Line 242: (p_ext_attrib_query_rec IN csi_datastructures_pub.extend_attrib_query_rec)

238:
239:
240:
241: PROCEDURE dump_ext_attrib_query_rec
242: (p_ext_attrib_query_rec IN csi_datastructures_pub.extend_attrib_query_rec)
243: IS
244: l_api_name CONSTANT VARCHAR2(30) := 'dump_ou_query_rec';
245: l_api_version CONSTANT NUMBER := 1.0;
246: BEGIN

Line 274: (p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec)

270: END dump_ext_attrib_query_rec;
271:
272:
273: PROCEDURE dump_ou_query_rec
274: (p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec)
275: IS
276: l_api_name CONSTANT VARCHAR2(30) := 'dump_ou_query_rec';
277: l_api_version CONSTANT NUMBER := 1.0;
278: BEGIN

Line 307: (p_instance_rec IN csi_datastructures_pub.instance_rec)

303:
304: END dump_ou_query_rec;
305:
306: PROCEDURE dump_instance_rec
307: (p_instance_rec IN csi_datastructures_pub.instance_rec)
308: IS
309: l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_rec';
310: l_api_version CONSTANT NUMBER := 1.0;
311: BEGIN

Line 444: (p_instance_query_rec IN csi_datastructures_pub.instance_query_rec)

440: END dump_instance_rec;
441:
442:
443: PROCEDURE dump_instance_query_rec
444: (p_instance_query_rec IN csi_datastructures_pub.instance_query_rec)
445: IS
446: l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_query_rec';
447: l_api_version CONSTANT NUMBER := 1.0;
448: BEGIN

Line 512: (p_instance_header_rec IN csi_datastructures_pub.instance_header_rec)

508: END dump_instance_query_rec;
509:
510:
511: PROCEDURE dump_instance_header_rec
512: (p_instance_header_rec IN csi_datastructures_pub.instance_header_rec)
513: IS
514: l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_header_rec';
515: l_api_version CONSTANT NUMBER := 1.0;
516: BEGIN

Line 707: (p_txn_rec IN csi_datastructures_pub.transaction_rec)

703:
704:
705:
706: PROCEDURE dump_txn_rec
707: (p_txn_rec IN csi_datastructures_pub.transaction_rec)
708: IS
709: l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_rec';
710: l_api_version CONSTANT NUMBER := 1.0;
711: BEGIN

Line 775: (p_txn_tbl IN csi_datastructures_pub.transaction_tbl)

771:
772: END dump_txn_rec;
773:
774: PROCEDURE dump_txn_tbl
775: (p_txn_tbl IN csi_datastructures_pub.transaction_tbl)
776: IS
777: l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_tbl';
778: l_api_version CONSTANT NUMBER := 1.0;
779: BEGIN

Line 810: (p_txn_query_rec IN csi_datastructures_pub.transaction_query_rec)

806:
807: END dump_txn_tbl;
808:
809: PROCEDURE dump_txn_query_rec
810: (p_txn_query_rec IN csi_datastructures_pub.transaction_query_rec)
811: IS
812: l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_query_rec';
813: l_api_version CONSTANT NUMBER := 1.0;
814: BEGIN

Line 856: (p_txn_sort_rec IN csi_datastructures_pub.transaction_sort_rec)

852:
853: END dump_txn_query_rec;
854:
855: PROCEDURE dump_txn_sort_rec
856: (p_txn_sort_rec IN csi_datastructures_pub.transaction_sort_rec)
857: IS
858: l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_query_rec';
859: l_api_version CONSTANT NUMBER := 1.0;
860: BEGIN

Line 887: (p_txn_error_rec IN csi_datastructures_pub.transaction_error_rec)

883:
884: END dump_txn_sort_rec;
885:
886: PROCEDURE dump_txn_error_rec
887: (p_txn_error_rec IN csi_datastructures_pub.transaction_error_rec)
888: IS
889: l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_error_rec';
890: l_api_version CONSTANT NUMBER := 1.0;
891: BEGIN

Line 935: (p_rel_rec IN csi_datastructures_pub.ii_relationship_rec)

931:
932: END dump_txn_error_rec;
933:
934: PROCEDURE dump_rel_rec
935: (p_rel_rec IN csi_datastructures_pub.ii_relationship_rec)
936: IS
937: l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_rec';
938: l_api_version CONSTANT NUMBER := 1.0;
939: BEGIN

Line 993: (p_rel_tbl IN csi_datastructures_pub.ii_relationship_tbl)

989: END dump_rel_rec;
990:
991:
992: PROCEDURE dump_rel_tbl
993: (p_rel_tbl IN csi_datastructures_pub.ii_relationship_tbl)
994: IS
995: l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_tbl';
996: l_api_version CONSTANT NUMBER := 1.0;
997: BEGIN

Line 1028: (p_rel_query_rec IN csi_datastructures_pub.relationship_query_rec)

1024:
1025: END dump_rel_tbl;
1026:
1027: PROCEDURE dump_rel_query_rec
1028: (p_rel_query_rec IN csi_datastructures_pub.relationship_query_rec)
1029: IS
1030: l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_query_rec';
1031: l_api_version CONSTANT NUMBER := 1.0;
1032: BEGIN

Line 1062: (P_system_rec IN csi_datastructures_pub.system_rec)

1058:
1059: END dump_rel_query_rec;
1060:
1061: PROCEDURE dump_sys_rec
1062: (P_system_rec IN csi_datastructures_pub.system_rec)
1063: IS
1064: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_rec';
1065: l_api_version CONSTANT NUMBER := 1.0;
1066: BEGIN

Line 1137: (p_systems_tbl IN csi_datastructures_pub.systems_tbl)

1133:
1134:
1135:
1136: PROCEDURE dump_sys_tbl
1137: (p_systems_tbl IN csi_datastructures_pub.systems_tbl)
1138: IS
1139: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_tbl';
1140: l_api_version CONSTANT NUMBER := 1.0;
1141: BEGIN

Line 1173: (p_system_query_rec IN csi_datastructures_pub.system_query_rec)

1169: END dump_sys_tbl;
1170:
1171:
1172: PROCEDURE dump_sys_query_rec
1173: (p_system_query_rec IN csi_datastructures_pub.system_query_rec)
1174: IS
1175: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_query_rec';
1176: l_api_version CONSTANT NUMBER := 1.0;
1177: BEGIN

Line 1207: (p_ext_attrib_rec IN csi_datastructures_pub.ext_attrib_rec)

1203:
1204: END dump_sys_query_rec;
1205:
1206: PROCEDURE dump_ext_attrib_rec
1207: (p_ext_attrib_rec IN csi_datastructures_pub.ext_attrib_rec)
1208: IS
1209: l_api_name CONSTANT VARCHAR2(30) := 'dump_ext_attrib_rec';
1210: l_api_version CONSTANT NUMBER := 1.0;
1211: BEGIN

Line 1264: (p_instance_party_id_lst IN csi_datastructures_pub.id_tbl

1260: END dump_ext_attrib_rec;
1261:
1262:
1263: PROCEDURE dump_inst_party_id
1264: (p_instance_party_id_lst IN csi_datastructures_pub.id_tbl
1265: ) IS
1266: l_api_name CONSTANT VARCHAR2(30) := 'dump_inst_party_id';
1267: l_api_version CONSTANT NUMBER := 1.0;
1268:

Line 1292: ( p_instance_asset_rec IN csi_datastructures_pub.instance_asset_rec

1288: END dump_inst_party_id ;
1289:
1290:
1291: PROCEDURE dump_instance_asset_rec
1292: ( p_instance_asset_rec IN csi_datastructures_pub.instance_asset_rec
1293: ) IS
1294: l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_asset_rec';
1295: l_api_version CONSTANT NUMBER := 1.0;
1296: BEGIN

Line 1331: (p_party_query_rec IN csi_datastructures_pub.party_query_rec

1327: END dump_instance_asset_rec;
1328:
1329:
1330: PROCEDURE dump_party_query_rec
1331: (p_party_query_rec IN csi_datastructures_pub.party_query_rec
1332: ) IS
1333: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_query_rec';
1334: l_api_version CONSTANT NUMBER := 1.0;
1335: BEGIN

Line 1363: (p_org_unit_rec IN csi_datastructures_pub.organization_units_rec)

1359: END dump_party_query_rec;
1360:
1361:
1362: PROCEDURE dump_organization_unit_rec
1363: (p_org_unit_rec IN csi_datastructures_pub.organization_units_rec)
1364: IS
1365: l_api_name CONSTANT VARCHAR2(30) := 'dump_organization_unit_rec';
1366: l_api_version CONSTANT NUMBER := 1.0;
1367: BEGIN

Line 1415: (p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl)

1411: END dump_organization_unit_rec;
1412:
1413:
1414: PROCEDURE dump_organization_unit_tbl
1415: (p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl)
1416: IS
1417: l_api_name CONSTANT VARCHAR2(30) := 'DUMP_ORGANIZATION_UNIT_TBL';
1418: l_api_version CONSTANT NUMBER := 1.0;
1419: BEGIN

Line 1477: (pricing_attribs_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec)

1473: END dump_organization_unit_tbl;
1474:
1475:
1476: PROCEDURE dump_pricing_attribs_query_rec
1477: (pricing_attribs_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec)
1478: IS
1479: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_query_rec';
1480: l_api_version CONSTANT NUMBER := 1.0;
1481: BEGIN

Line 1509: (p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec)

1505: END dump_pricing_attribs_query_rec;
1506:
1507:
1508: PROCEDURE dump_pricing_attribs_rec
1509: (p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec)
1510: IS
1511: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_rec';
1512: l_api_version CONSTANT NUMBER := 1.0;
1513: BEGIN

Line 1660: (p_pricing_attribs_tbl IN csi_datastructures_pub.pricing_attribs_tbl)

1656:
1657: END dump_pricing_attribs_rec;
1658:
1659: PROCEDURE dump_pricing_attribs_tbl
1660: (p_pricing_attribs_tbl IN csi_datastructures_pub.pricing_attribs_tbl)
1661: IS
1662: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_tbl';
1663: l_api_version CONSTANT NUMBER := 1.0;
1664: BEGIN

Line 1821: ( p_party_rec IN csi_datastructures_pub.party_rec

1817: END dump_pricing_attribs_tbl;
1818:
1819:
1820: PROCEDURE dump_party_rec
1821: ( p_party_rec IN csi_datastructures_pub.party_rec
1822: ) IS
1823: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_rec';
1824: l_api_version CONSTANT NUMBER := 1.0;
1825: BEGIN

Line 1874: (p_party_tbl IN csi_datastructures_pub.party_tbl)

1870: END dump_party_rec;
1871:
1872:
1873: PROCEDURE dump_party_tbl
1874: (p_party_tbl IN csi_datastructures_pub.party_tbl)
1875: IS
1876: l_api_name CONSTANT VARCHAR2(30) := 'DUMP_PARTY_TBL';
1877: l_api_version CONSTANT NUMBER := 1.0;
1878: BEGIN

Line 1931: ( p_version_label_rec IN csi_datastructures_pub.version_label_rec

1927: END IF;
1928: END dump_party_tbl;
1929:
1930: PROCEDURE dump_version_label_rec
1931: ( p_version_label_rec IN csi_datastructures_pub.version_label_rec
1932: ) IS
1933:
1934: l_api_name CONSTANT VARCHAR2(30) := 'dump_version_label_rec';
1935: l_api_version CONSTANT NUMBER := 1.0;

Line 1982: ( p_version_label_tbl IN csi_datastructures_pub.version_label_tbl

1978: END IF;
1979: END dump_version_label_rec;
1980:
1981: PROCEDURE dump_version_label_tbl
1982: ( p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
1983: ) IS
1984:
1985: l_api_name CONSTANT VARCHAR2(30) := 'dump_version_label_tbl';
1986: l_api_version CONSTANT NUMBER := 1.0;

Line 2038: (p_party_account_tbl IN csi_datastructures_pub.party_account_tbl

2034: END dump_version_label_tbl;
2035:
2036:
2037: PROCEDURE dump_party_account_tbl
2038: (p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
2039: ) IS
2040: l_api_name CONSTANT VARCHAR2(30) := 'DUMP_PARTY_ACCOUNT_TBL';
2041: l_api_version CONSTANT NUMBER := 1.0;
2042:

Line 2095: ( p_party_account_rec IN csi_datastructures_pub.party_account_rec

2091: END IF;
2092: END dump_party_account_tbl;
2093:
2094: PROCEDURE dump_party_account_rec
2095: ( p_party_account_rec IN csi_datastructures_pub.party_account_rec
2096: ) IS
2097: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_account_rec';
2098: l_api_version CONSTANT NUMBER := 1.0;
2099: BEGIN

Line 2148: (p_account_query_rec IN csi_datastructures_pub.party_account_query_rec

2144: END dump_party_account_rec;
2145:
2146:
2147: PROCEDURE dump_account_query_rec
2148: (p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
2149: ) IS
2150:
2151: l_api_name CONSTANT VARCHAR2(30) := 'dump_account_query_rec';
2152: l_api_version CONSTANT NUMBER := 1.0;

Line 2178: ( p_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec

2174: END IF;
2175: END dump_account_query_rec ;
2176:
2177: PROCEDURE dump_asset_query_rec
2178: ( p_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
2179: ) IS
2180:
2181: l_api_name CONSTANT VARCHAR2(30) := 'dump_asset_query_rec';
2182: l_api_version CONSTANT NUMBER := 1.0;

Line 2210: ( p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec

2206: END IF;
2207: END dump_asset_query_rec ;
2208:
2209: PROCEDURE dump_ver_label_query_rec
2210: ( p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
2211: )IS
2212:
2213: l_api_name CONSTANT VARCHAR2(30) := 'dump_ver_label_query_rec';
2214: l_api_version CONSTANT NUMBER := 1.0;

Line 2241: (id_tbl IN csi_datastructures_pub.id_tbl)

2237: END dump_ver_label_query_rec ;
2238:
2239:
2240: PROCEDURE dump_id_tbl
2241: (id_tbl IN csi_datastructures_pub.id_tbl)
2242: IS
2243: l_api_name CONSTANT VARCHAR2(30) := 'dump_id_tbl';
2244: l_api_version CONSTANT NUMBER := 1.0;
2245: BEGIN

Line 2346: ,p_parameter_name IN csi_datastructures_pub.parameter_name

2342:
2343: PROCEDURE dump_call_batch_val
2344: ( p_api_version IN NUMBER
2345: ,p_init_msg_list IN VARCHAR2
2346: ,p_parameter_name IN csi_datastructures_pub.parameter_name
2347: ,p_parameter_value IN csi_datastructures_pub.parameter_value
2348: )
2349: IS
2350: l_api_name CONSTANT VARCHAR2(30) := 'dump_call_batch_val';

Line 2347: ,p_parameter_value IN csi_datastructures_pub.parameter_value

2343: PROCEDURE dump_call_batch_val
2344: ( p_api_version IN NUMBER
2345: ,p_init_msg_list IN VARCHAR2
2346: ,p_parameter_name IN csi_datastructures_pub.parameter_name
2347: ,p_parameter_value IN csi_datastructures_pub.parameter_value
2348: )
2349: IS
2350: l_api_name CONSTANT VARCHAR2(30) := 'dump_call_batch_val';
2351: l_api_version CONSTANT NUMBER := 1.0;

Line 2394: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID

2390: ,TXN_SEQ_START_DATE
2391: ,nvl(OWNERSHIP_CASCADE_AT_TXN,'N')
2392: ,'Y'
2393: ,FA_CREATION_GROUP_BY
2394: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
2395: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2396: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2397: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2398: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID

Line 2395: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID

2391: ,nvl(OWNERSHIP_CASCADE_AT_TXN,'N')
2392: ,'Y'
2393: ,FA_CREATION_GROUP_BY
2394: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
2395: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2396: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2397: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2398: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2399: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID

Line 2396: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID

2392: ,'Y'
2393: ,FA_CREATION_GROUP_BY
2394: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
2395: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2396: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2397: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2398: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2399: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2400: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY

Line 2397: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID

2393: ,FA_CREATION_GROUP_BY
2394: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
2395: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2396: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2397: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2398: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2399: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2400: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2401: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG

Line 2398: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID

2394: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
2395: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2396: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2397: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2398: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2399: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2400: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2401: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2402: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE

Line 2399: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID

2395: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2396: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2397: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2398: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2399: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2400: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2401: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2402: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2403: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION

Line 2400: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY

2396: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2397: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2398: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2399: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2400: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2401: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2402: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2403: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN

Line 2401: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG

2397: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2398: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2399: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2400: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2401: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2402: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2403: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG

Line 2402: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE

2398: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2399: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2400: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2401: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2402: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2403: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP

Line 2403: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION

2399: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2400: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2401: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2402: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2403: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE

Line 2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN

2400: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2401: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2402: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2403: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN

Line 2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG

2401: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2402: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2403: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG

Line 2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP

2402: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2403: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY

Line 2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE

2403: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
2411: FROM CSI_INSTALL_PARAMETERS;

Line 2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN

2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
2411: FROM CSI_INSTALL_PARAMETERS;
2412: EXCEPTION

Line 2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG

2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
2411: FROM CSI_INSTALL_PARAMETERS;
2412: EXCEPTION
2413: WHEN OTHERS THEN

Line 2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY

2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
2411: FROM CSI_INSTALL_PARAMETERS;
2412: EXCEPTION
2413: WHEN OTHERS THEN
2414: csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG := 'N';

Line 2414: csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG := 'N';

2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
2411: FROM CSI_INSTALL_PARAMETERS;
2412: EXCEPTION
2413: WHEN OTHERS THEN
2414: csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG := 'N';
2415: END Populate_Install_Param_Rec;
2416: --
2417: FUNCTION IB_ACTIVE RETURN BOOLEAN IS
2418: l_freeze_flag VARCHAR2(1) := 'N';

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

2416: --
2417: FUNCTION IB_ACTIVE RETURN BOOLEAN IS
2418: l_freeze_flag VARCHAR2(1) := 'N';
2419: BEGIN
2420: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2421: csi_gen_utility_pvt.populate_install_param_rec;
2422: END IF;
2423: --
2424: l_freeze_flag := csi_datastructures_pub.g_install_param_rec.freeze_flag;

Line 2424: l_freeze_flag := csi_datastructures_pub.g_install_param_rec.freeze_flag;

2420: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2421: csi_gen_utility_pvt.populate_install_param_rec;
2422: END IF;
2423: --
2424: l_freeze_flag := csi_datastructures_pub.g_install_param_rec.freeze_flag;
2425: --
2426: IF nvl(l_freeze_flag,'N') = 'Y' THEN
2427: return TRUE;
2428: ELSE