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 1001: (p_rel_tbl IN csi_datastructures_pub.ii_relationship_tbl)

997: END dump_rel_rec;
998:
999:
1000: PROCEDURE dump_rel_tbl
1001: (p_rel_tbl IN csi_datastructures_pub.ii_relationship_tbl)
1002: IS
1003: l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_tbl';
1004: l_api_version CONSTANT NUMBER := 1.0;
1005: BEGIN

Line 1036: (p_rel_query_rec IN csi_datastructures_pub.relationship_query_rec)

1032:
1033: END dump_rel_tbl;
1034:
1035: PROCEDURE dump_rel_query_rec
1036: (p_rel_query_rec IN csi_datastructures_pub.relationship_query_rec)
1037: IS
1038: l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_query_rec';
1039: l_api_version CONSTANT NUMBER := 1.0;
1040: BEGIN

Line 1070: (P_system_rec IN csi_datastructures_pub.system_rec)

1066:
1067: END dump_rel_query_rec;
1068:
1069: PROCEDURE dump_sys_rec
1070: (P_system_rec IN csi_datastructures_pub.system_rec)
1071: IS
1072: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_rec';
1073: l_api_version CONSTANT NUMBER := 1.0;
1074: BEGIN

Line 1145: (p_systems_tbl IN csi_datastructures_pub.systems_tbl)

1141:
1142:
1143:
1144: PROCEDURE dump_sys_tbl
1145: (p_systems_tbl IN csi_datastructures_pub.systems_tbl)
1146: IS
1147: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_tbl';
1148: l_api_version CONSTANT NUMBER := 1.0;
1149: BEGIN

Line 1181: (p_system_query_rec IN csi_datastructures_pub.system_query_rec)

1177: END dump_sys_tbl;
1178:
1179:
1180: PROCEDURE dump_sys_query_rec
1181: (p_system_query_rec IN csi_datastructures_pub.system_query_rec)
1182: IS
1183: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_query_rec';
1184: l_api_version CONSTANT NUMBER := 1.0;
1185: BEGIN

Line 1215: (p_ext_attrib_rec IN csi_datastructures_pub.ext_attrib_rec)

1211:
1212: END dump_sys_query_rec;
1213:
1214: PROCEDURE dump_ext_attrib_rec
1215: (p_ext_attrib_rec IN csi_datastructures_pub.ext_attrib_rec)
1216: IS
1217: l_api_name CONSTANT VARCHAR2(30) := 'dump_ext_attrib_rec';
1218: l_api_version CONSTANT NUMBER := 1.0;
1219: BEGIN

Line 1272: (p_instance_party_id_lst IN csi_datastructures_pub.id_tbl

1268: END dump_ext_attrib_rec;
1269:
1270:
1271: PROCEDURE dump_inst_party_id
1272: (p_instance_party_id_lst IN csi_datastructures_pub.id_tbl
1273: ) IS
1274: l_api_name CONSTANT VARCHAR2(30) := 'dump_inst_party_id';
1275: l_api_version CONSTANT NUMBER := 1.0;
1276:

Line 1300: ( p_instance_asset_rec IN csi_datastructures_pub.instance_asset_rec

1296: END dump_inst_party_id ;
1297:
1298:
1299: PROCEDURE dump_instance_asset_rec
1300: ( p_instance_asset_rec IN csi_datastructures_pub.instance_asset_rec
1301: ) IS
1302: l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_asset_rec';
1303: l_api_version CONSTANT NUMBER := 1.0;
1304: BEGIN

Line 1339: (p_party_query_rec IN csi_datastructures_pub.party_query_rec

1335: END dump_instance_asset_rec;
1336:
1337:
1338: PROCEDURE dump_party_query_rec
1339: (p_party_query_rec IN csi_datastructures_pub.party_query_rec
1340: ) IS
1341: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_query_rec';
1342: l_api_version CONSTANT NUMBER := 1.0;
1343: BEGIN

Line 1371: (p_org_unit_rec IN csi_datastructures_pub.organization_units_rec)

1367: END dump_party_query_rec;
1368:
1369:
1370: PROCEDURE dump_organization_unit_rec
1371: (p_org_unit_rec IN csi_datastructures_pub.organization_units_rec)
1372: IS
1373: l_api_name CONSTANT VARCHAR2(30) := 'dump_organization_unit_rec';
1374: l_api_version CONSTANT NUMBER := 1.0;
1375: BEGIN

Line 1423: (p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl)

1419: END dump_organization_unit_rec;
1420:
1421:
1422: PROCEDURE dump_organization_unit_tbl
1423: (p_org_unit_tbl IN csi_datastructures_pub.organization_units_tbl)
1424: IS
1425: l_api_name CONSTANT VARCHAR2(30) := 'DUMP_ORGANIZATION_UNIT_TBL';
1426: l_api_version CONSTANT NUMBER := 1.0;
1427: BEGIN

Line 1485: (pricing_attribs_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec)

1481: END dump_organization_unit_tbl;
1482:
1483:
1484: PROCEDURE dump_pricing_attribs_query_rec
1485: (pricing_attribs_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec)
1486: IS
1487: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_query_rec';
1488: l_api_version CONSTANT NUMBER := 1.0;
1489: BEGIN

Line 1517: (p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec)

1513: END dump_pricing_attribs_query_rec;
1514:
1515:
1516: PROCEDURE dump_pricing_attribs_rec
1517: (p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec)
1518: IS
1519: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_rec';
1520: l_api_version CONSTANT NUMBER := 1.0;
1521: BEGIN

Line 1668: (p_pricing_attribs_tbl IN csi_datastructures_pub.pricing_attribs_tbl)

1664:
1665: END dump_pricing_attribs_rec;
1666:
1667: PROCEDURE dump_pricing_attribs_tbl
1668: (p_pricing_attribs_tbl IN csi_datastructures_pub.pricing_attribs_tbl)
1669: IS
1670: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_tbl';
1671: l_api_version CONSTANT NUMBER := 1.0;
1672: BEGIN

Line 1829: ( p_party_rec IN csi_datastructures_pub.party_rec

1825: END dump_pricing_attribs_tbl;
1826:
1827:
1828: PROCEDURE dump_party_rec
1829: ( p_party_rec IN csi_datastructures_pub.party_rec
1830: ) IS
1831: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_rec';
1832: l_api_version CONSTANT NUMBER := 1.0;
1833: BEGIN

Line 1882: (p_party_tbl IN csi_datastructures_pub.party_tbl)

1878: END dump_party_rec;
1879:
1880:
1881: PROCEDURE dump_party_tbl
1882: (p_party_tbl IN csi_datastructures_pub.party_tbl)
1883: IS
1884: l_api_name CONSTANT VARCHAR2(30) := 'DUMP_PARTY_TBL';
1885: l_api_version CONSTANT NUMBER := 1.0;
1886: BEGIN

Line 1940: ( p_version_label_rec IN csi_datastructures_pub.version_label_rec

1936: END IF;
1937: END dump_party_tbl;
1938:
1939: PROCEDURE dump_version_label_rec
1940: ( p_version_label_rec IN csi_datastructures_pub.version_label_rec
1941: ) IS
1942:
1943: l_api_name CONSTANT VARCHAR2(30) := 'dump_version_label_rec';
1944: l_api_version CONSTANT NUMBER := 1.0;

Line 1991: ( p_version_label_tbl IN csi_datastructures_pub.version_label_tbl

1987: END IF;
1988: END dump_version_label_rec;
1989:
1990: PROCEDURE dump_version_label_tbl
1991: ( p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
1992: ) IS
1993:
1994: l_api_name CONSTANT VARCHAR2(30) := 'dump_version_label_tbl';
1995: l_api_version CONSTANT NUMBER := 1.0;

Line 2047: (p_party_account_tbl IN csi_datastructures_pub.party_account_tbl

2043: END dump_version_label_tbl;
2044:
2045:
2046: PROCEDURE dump_party_account_tbl
2047: (p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
2048: ) IS
2049: l_api_name CONSTANT VARCHAR2(30) := 'DUMP_PARTY_ACCOUNT_TBL';
2050: l_api_version CONSTANT NUMBER := 1.0;
2051:

Line 2104: ( p_party_account_rec IN csi_datastructures_pub.party_account_rec

2100: END IF;
2101: END dump_party_account_tbl;
2102:
2103: PROCEDURE dump_party_account_rec
2104: ( p_party_account_rec IN csi_datastructures_pub.party_account_rec
2105: ) IS
2106: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_account_rec';
2107: l_api_version CONSTANT NUMBER := 1.0;
2108: BEGIN

Line 2157: (p_account_query_rec IN csi_datastructures_pub.party_account_query_rec

2153: END dump_party_account_rec;
2154:
2155:
2156: PROCEDURE dump_account_query_rec
2157: (p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
2158: ) IS
2159:
2160: l_api_name CONSTANT VARCHAR2(30) := 'dump_account_query_rec';
2161: l_api_version CONSTANT NUMBER := 1.0;

Line 2187: ( p_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec

2183: END IF;
2184: END dump_account_query_rec ;
2185:
2186: PROCEDURE dump_asset_query_rec
2187: ( p_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
2188: ) IS
2189:
2190: l_api_name CONSTANT VARCHAR2(30) := 'dump_asset_query_rec';
2191: l_api_version CONSTANT NUMBER := 1.0;

Line 2219: ( p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec

2215: END IF;
2216: END dump_asset_query_rec ;
2217:
2218: PROCEDURE dump_ver_label_query_rec
2219: ( p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
2220: )IS
2221:
2222: l_api_name CONSTANT VARCHAR2(30) := 'dump_ver_label_query_rec';
2223: l_api_version CONSTANT NUMBER := 1.0;

Line 2250: (id_tbl IN csi_datastructures_pub.id_tbl)

2246: END dump_ver_label_query_rec ;
2247:
2248:
2249: PROCEDURE dump_id_tbl
2250: (id_tbl IN csi_datastructures_pub.id_tbl)
2251: IS
2252: l_api_name CONSTANT VARCHAR2(30) := 'dump_id_tbl';
2253: l_api_version CONSTANT NUMBER := 1.0;
2254: BEGIN

Line 2355: ,p_parameter_name IN csi_datastructures_pub.parameter_name

2351:
2352: PROCEDURE dump_call_batch_val
2353: ( p_api_version IN NUMBER
2354: ,p_init_msg_list IN VARCHAR2
2355: ,p_parameter_name IN csi_datastructures_pub.parameter_name
2356: ,p_parameter_value IN csi_datastructures_pub.parameter_value
2357: )
2358: IS
2359: l_api_name CONSTANT VARCHAR2(30) := 'dump_call_batch_val';

Line 2356: ,p_parameter_value IN csi_datastructures_pub.parameter_value

2352: PROCEDURE dump_call_batch_val
2353: ( p_api_version IN NUMBER
2354: ,p_init_msg_list IN VARCHAR2
2355: ,p_parameter_name IN csi_datastructures_pub.parameter_name
2356: ,p_parameter_value IN csi_datastructures_pub.parameter_value
2357: )
2358: IS
2359: l_api_name CONSTANT VARCHAR2(30) := 'dump_call_batch_val';
2360: l_api_version CONSTANT NUMBER := 1.0;

Line 2403: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID

2399: ,TXN_SEQ_START_DATE
2400: ,nvl(OWNERSHIP_CASCADE_AT_TXN,'N')
2401: ,'Y'
2402: ,FA_CREATION_GROUP_BY
2403: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID

Line 2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID

2400: ,nvl(OWNERSHIP_CASCADE_AT_TXN,'N')
2401: ,'Y'
2402: ,FA_CREATION_GROUP_BY
2403: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID

Line 2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID

2401: ,'Y'
2402: ,FA_CREATION_GROUP_BY
2403: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY

Line 2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID

2402: ,FA_CREATION_GROUP_BY
2403: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG

Line 2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID

2403: INTO csi_datastructures_pub.G_INSTALL_PARAM_REC.INTERNAL_PARTY_ID
2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2411: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE

Line 2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID

2404: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PROJECT_LOCATION_ID
2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2411: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2412: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION

Line 2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY

2405: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.WIP_LOCATION_ID
2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2411: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2412: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2413: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN

Line 2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG

2406: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.IN_TRANSIT_LOCATION_ID
2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2411: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2412: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2413: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2414: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG

Line 2411: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE

2407: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.PO_LOCATION_ID
2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2411: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2412: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2413: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2414: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2415: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP

Line 2412: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION

2408: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.CATEGORY_SET_ID
2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2411: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2412: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2413: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2414: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2415: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2416: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE

Line 2413: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN

2409: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.HISTORY_FULL_DUMP_FREQUENCY
2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2411: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2412: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2413: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2414: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2415: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2416: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2417: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN

Line 2414: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG

2410: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_FLAG
2411: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2412: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2413: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2414: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2415: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2416: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2417: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2418: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG

Line 2415: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP

2411: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FREEZE_DATE
2412: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2413: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2414: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2415: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2416: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2417: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2418: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
2419: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY

Line 2416: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE

2412: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SHOW_ALL_PARTY_LOCATION
2413: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2414: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2415: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2416: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2417: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2418: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
2419: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
2420: FROM CSI_INSTALL_PARAMETERS;

Line 2417: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN

2413: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_OVERRIDE_AT_TXN
2414: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2415: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2416: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2417: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2418: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
2419: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
2420: FROM CSI_INSTALL_PARAMETERS;
2421: EXCEPTION

Line 2418: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG

2414: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.SFM_QUEUE_BYPASS_FLAG
2415: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2416: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2417: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2418: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
2419: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
2420: FROM CSI_INSTALL_PARAMETERS;
2421: EXCEPTION
2422: WHEN OTHERS THEN

Line 2419: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY

2415: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.AUTO_ALLOCATE_COMP_AT_WIP
2416: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.TXN_SEQ_START_DATE
2417: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.OWNERSHIP_CASCADE_AT_TXN
2418: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG
2419: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
2420: FROM CSI_INSTALL_PARAMETERS;
2421: EXCEPTION
2422: WHEN OTHERS THEN
2423: csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG := 'N';

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

2419: ,csi_datastructures_pub.G_INSTALL_PARAM_REC.FA_CREATION_GROUP_BY
2420: FROM CSI_INSTALL_PARAMETERS;
2421: EXCEPTION
2422: WHEN OTHERS THEN
2423: csi_datastructures_pub.G_INSTALL_PARAM_REC.FETCH_FLAG := 'N';
2424: END Populate_Install_Param_Rec;
2425: --
2426: FUNCTION IB_ACTIVE RETURN BOOLEAN IS
2427: l_freeze_flag VARCHAR2(1) := 'N';

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

2425: --
2426: FUNCTION IB_ACTIVE RETURN BOOLEAN IS
2427: l_freeze_flag VARCHAR2(1) := 'N';
2428: BEGIN
2429: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2430: csi_gen_utility_pvt.populate_install_param_rec;
2431: END IF;
2432: --
2433: l_freeze_flag := csi_datastructures_pub.g_install_param_rec.freeze_flag;

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

2429: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2430: csi_gen_utility_pvt.populate_install_param_rec;
2431: END IF;
2432: --
2433: l_freeze_flag := csi_datastructures_pub.g_install_param_rec.freeze_flag;
2434: --
2435: IF nvl(l_freeze_flag,'N') = 'Y' THEN
2436: return TRUE;
2437: ELSE