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

Line 48: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

44: p_api_version IN NUMBER
45: ,p_commit IN VARCHAR2
46: ,p_init_msg_list IN VARCHAR2
47: ,p_validation_level IN NUMBER
48: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
49: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
50: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
51: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
52: ,x_return_status OUT NOCOPY VARCHAR2

Line 49: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

45: ,p_commit IN VARCHAR2
46: ,p_init_msg_list IN VARCHAR2
47: ,p_validation_level IN NUMBER
48: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
49: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
50: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
51: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
52: ,x_return_status OUT NOCOPY VARCHAR2
53: ,x_msg_count OUT NOCOPY NUMBER

Line 50: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

46: ,p_init_msg_list IN VARCHAR2
47: ,p_validation_level IN NUMBER
48: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
49: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
50: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
51: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
52: ,x_return_status OUT NOCOPY VARCHAR2
53: ,x_msg_count OUT NOCOPY NUMBER
54: ,x_msg_data OUT NOCOPY VARCHAR2

Line 51: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

47: ,p_validation_level IN NUMBER
48: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
49: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
50: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
51: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
52: ,x_return_status OUT NOCOPY VARCHAR2
53: ,x_msg_count OUT NOCOPY NUMBER
54: ,x_msg_data OUT NOCOPY VARCHAR2
55: )

Line 59: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

55: )
56: IS
57: l_api_name CONSTANT VARCHAR2(30) := 'create_item_instance';
58: l_api_version CONSTANT NUMBER := 1.0;
59: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
60: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
61: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
62: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
63: BEGIN

Line 60: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

56: IS
57: l_api_name CONSTANT VARCHAR2(30) := 'create_item_instance';
58: l_api_version CONSTANT NUMBER := 1.0;
59: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
60: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
61: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
62: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
63: BEGIN
64:

Line 61: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

57: l_api_name CONSTANT VARCHAR2(30) := 'create_item_instance';
58: l_api_version CONSTANT NUMBER := 1.0;
59: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
60: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
61: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
62: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
63: BEGIN
64:
65: SAVEPOINT create_item_instance;

Line 62: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

58: l_api_version CONSTANT NUMBER := 1.0;
59: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
60: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
61: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
62: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
63: BEGIN
64:
65: SAVEPOINT create_item_instance;
66:

Line 263: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec

259: p_api_version IN NUMBER
260: ,p_commit IN VARCHAR2
261: ,p_init_msg_list IN VARCHAR2
262: ,p_validation_level IN NUMBER
263: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
264: ,p_copy_ext_attribs IN VARCHAR2
265: ,p_copy_org_assignments IN VARCHAR2
266: ,p_copy_parties IN VARCHAR2
267: ,p_copy_contacts IN VARCHAR2

Line 272: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

268: ,p_copy_accounts IN VARCHAR2
269: ,p_copy_asset_assignments IN VARCHAR2
270: ,p_copy_pricing_attribs IN VARCHAR2
271: ,p_copy_inst_children IN VARCHAR2
272: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
273: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
274: ,x_return_status OUT NOCOPY VARCHAR2
275: ,x_msg_count OUT NOCOPY NUMBER
276: ,x_msg_data OUT NOCOPY VARCHAR2

Line 273: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

269: ,p_copy_asset_assignments IN VARCHAR2
270: ,p_copy_pricing_attribs IN VARCHAR2
271: ,p_copy_inst_children IN VARCHAR2
272: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
273: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
274: ,x_return_status OUT NOCOPY VARCHAR2
275: ,x_msg_count OUT NOCOPY NUMBER
276: ,x_msg_data OUT NOCOPY VARCHAR2
277: )

Line 358: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

354: p_api_version IN NUMBER
355: ,p_commit IN VARCHAR2
356: ,p_init_msg_list IN VARCHAR2
357: ,p_validation_level IN NUMBER
358: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
359: ,p_quantity1 IN NUMBER
360: ,p_quantity2 IN NUMBER
361: ,p_copy_ext_attribs IN VARCHAR2
362: ,p_copy_org_assignments IN VARCHAR2

Line 367: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

363: ,p_copy_parties IN VARCHAR2
364: ,p_copy_accounts IN VARCHAR2
365: ,p_copy_asset_assignments IN VARCHAR2
366: ,p_copy_pricing_attribs IN VARCHAR2
367: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
368: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
369: ,x_return_status OUT NOCOPY VARCHAR2
370: ,x_msg_count OUT NOCOPY NUMBER
371: ,x_msg_data OUT NOCOPY VARCHAR2

Line 368: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec

364: ,p_copy_accounts IN VARCHAR2
365: ,p_copy_asset_assignments IN VARCHAR2
366: ,p_copy_pricing_attribs IN VARCHAR2
367: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
368: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
369: ,x_return_status OUT NOCOPY VARCHAR2
370: ,x_msg_count OUT NOCOPY NUMBER
371: ,x_msg_data OUT NOCOPY VARCHAR2
372: )

Line 452: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

448: p_api_version IN NUMBER
449: ,p_commit IN VARCHAR2
450: ,p_init_msg_list IN VARCHAR2
451: ,p_validation_level IN NUMBER
452: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
453: ,p_copy_ext_attribs IN VARCHAR2
454: ,p_copy_org_assignments IN VARCHAR2
455: ,p_copy_parties IN VARCHAR2
456: ,p_copy_accounts IN VARCHAR2

Line 459: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

455: ,p_copy_parties IN VARCHAR2
456: ,p_copy_accounts IN VARCHAR2
457: ,p_copy_asset_assignments IN VARCHAR2
458: ,p_copy_pricing_attribs IN VARCHAR2
459: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
460: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
461: ,x_return_status OUT NOCOPY VARCHAR2
462: ,x_msg_count OUT NOCOPY NUMBER
463: ,x_msg_data OUT NOCOPY VARCHAR2

Line 460: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

456: ,p_copy_accounts IN VARCHAR2
457: ,p_copy_asset_assignments IN VARCHAR2
458: ,p_copy_pricing_attribs IN VARCHAR2
459: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
460: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
461: ,x_return_status OUT NOCOPY VARCHAR2
462: ,x_msg_count OUT NOCOPY NUMBER
463: ,x_msg_data OUT NOCOPY VARCHAR2
464: )

Line 1052: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl

1048: ,p_init_msg_list IN VARCHAR2
1049: ,p_validation_level IN NUMBER
1050: ,p_transaction_id IN NUMBER
1051: ,p_instance_id IN NUMBER
1052: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
1053: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl
1054: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl
1055: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1056: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl

Line 1053: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl

1049: ,p_validation_level IN NUMBER
1050: ,p_transaction_id IN NUMBER
1051: ,p_instance_id IN NUMBER
1052: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
1053: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl
1054: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl
1055: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1056: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
1057: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl

Line 1054: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl

1050: ,p_transaction_id IN NUMBER
1051: ,p_instance_id IN NUMBER
1052: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
1053: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl
1054: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl
1055: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1056: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
1057: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
1058: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl

Line 1055: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl

1051: ,p_instance_id IN NUMBER
1052: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
1053: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl
1054: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl
1055: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1056: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
1057: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
1058: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
1059: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl

Line 1056: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl

1052: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
1053: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl
1054: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl
1055: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1056: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
1057: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
1058: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
1059: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl
1060: ,x_return_status OUT NOCOPY VARCHAR2

Line 1057: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl

1053: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl
1054: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl
1055: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1056: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
1057: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
1058: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
1059: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl
1060: ,x_return_status OUT NOCOPY VARCHAR2
1061: ,x_msg_count OUT NOCOPY NUMBER

Line 1058: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl

1054: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl
1055: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1056: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
1057: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
1058: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
1059: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl
1060: ,x_return_status OUT NOCOPY VARCHAR2
1061: ,x_msg_count OUT NOCOPY NUMBER
1062: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1059: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl

1055: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1056: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
1057: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
1058: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
1059: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl
1060: ,x_return_status OUT NOCOPY VARCHAR2
1061: ,x_msg_count OUT NOCOPY NUMBER
1062: ,x_msg_data OUT NOCOPY VARCHAR2
1063: ) IS

Line 1067: temp_instance_history_tbl csi_datastructures_pub.instance_history_tbl;

1063: ) IS
1064: l_dummy VARCHAR2(1);
1065: l_api_name CONSTANT VARCHAR2(30) := 'get_history_transactions';
1066: l_api_version CONSTANT NUMBER := 1.0;
1067: temp_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
1068: temp_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
1069: temp_party_history_tbl csi_datastructures_pub.party_history_tbl;
1070: temp_account_history_tbl csi_datastructures_pub.account_history_tbl;
1071: temp_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;

Line 1068: temp_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;

1064: l_dummy VARCHAR2(1);
1065: l_api_name CONSTANT VARCHAR2(30) := 'get_history_transactions';
1066: l_api_version CONSTANT NUMBER := 1.0;
1067: temp_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
1068: temp_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
1069: temp_party_history_tbl csi_datastructures_pub.party_history_tbl;
1070: temp_account_history_tbl csi_datastructures_pub.account_history_tbl;
1071: temp_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
1072: temp_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;

Line 1069: temp_party_history_tbl csi_datastructures_pub.party_history_tbl;

1065: l_api_name CONSTANT VARCHAR2(30) := 'get_history_transactions';
1066: l_api_version CONSTANT NUMBER := 1.0;
1067: temp_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
1068: temp_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
1069: temp_party_history_tbl csi_datastructures_pub.party_history_tbl;
1070: temp_account_history_tbl csi_datastructures_pub.account_history_tbl;
1071: temp_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
1072: temp_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
1073: temp_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;

Line 1070: temp_account_history_tbl csi_datastructures_pub.account_history_tbl;

1066: l_api_version CONSTANT NUMBER := 1.0;
1067: temp_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
1068: temp_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
1069: temp_party_history_tbl csi_datastructures_pub.party_history_tbl;
1070: temp_account_history_tbl csi_datastructures_pub.account_history_tbl;
1071: temp_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
1072: temp_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
1073: temp_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
1074: x_index number;

Line 1071: temp_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;

1067: temp_instance_history_tbl csi_datastructures_pub.instance_history_tbl;
1068: temp_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
1069: temp_party_history_tbl csi_datastructures_pub.party_history_tbl;
1070: temp_account_history_tbl csi_datastructures_pub.account_history_tbl;
1071: temp_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
1072: temp_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
1073: temp_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
1074: x_index number;
1075:

Line 1072: temp_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;

1068: temp_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
1069: temp_party_history_tbl csi_datastructures_pub.party_history_tbl;
1070: temp_account_history_tbl csi_datastructures_pub.account_history_tbl;
1071: temp_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
1072: temp_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
1073: temp_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
1074: x_index number;
1075:
1076: BEGIN

Line 1073: temp_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;

1069: temp_party_history_tbl csi_datastructures_pub.party_history_tbl;
1070: temp_account_history_tbl csi_datastructures_pub.account_history_tbl;
1071: temp_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;
1072: temp_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
1073: temp_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;
1074: x_index number;
1075:
1076: BEGIN
1077:

Line 1550: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec

1546: ,p_commit IN VARCHAR2
1547: ,p_init_msg_list IN VARCHAR2
1548: ,p_validation_level IN NUMBER
1549: ,p_instance_id IN NUMBER
1550: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec
1551: ,x_return_status OUT NOCOPY VARCHAR2
1552: ,x_msg_count OUT NOCOPY NUMBER
1553: ,x_msg_data OUT NOCOPY VARCHAR2
1554: )

Line 1559: --l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

1555: IS
1556: l_api_name CONSTANT VARCHAR2(30) := 'GET_INSTANCE_LINK_LOCATIONS';
1557: l_api_version CONSTANT NUMBER := 1.0;
1558: l_debug_level NUMBER;
1559: --l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1560:
1561: BEGIN
1562: SAVEPOINT get_instance_link_location;
1563:

Line 1621: p_rel_tbl1 in csi_datastructures_pub.ii_relationship_tbl,

1617:
1618: Procedure bld_data_for_conn_rec
1619: (
1620: p_connected_relationship_tbl in out NOCOPY connected_relationship_tbl,
1621: p_rel_tbl1 in csi_datastructures_pub.ii_relationship_tbl,
1622: p_instanceid_tbl in out NOCOPY instanceid_tbl,
1623: p_instanceid_tbl1 in out NOCOPY instanceid_tbl1,
1624: i in number
1625: )

Line 1700: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

1696: l_api_version number := 1.0;
1697: l_commit varchar2(1) := fnd_api.g_false;
1698: l_init_msg_list varchar2(1) := fnd_api.g_false;
1699: l_validation_level number := fnd_api.g_valid_level_full;
1700: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1701: l_rel_tbl1 csi_datastructures_pub.ii_relationship_tbl;
1702: l_msg_count number;
1703: l_msg_data varchar2(240);
1704: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1701: l_rel_tbl1 csi_datastructures_pub.ii_relationship_tbl;

1697: l_commit varchar2(1) := fnd_api.g_false;
1698: l_init_msg_list varchar2(1) := fnd_api.g_false;
1699: l_validation_level number := fnd_api.g_valid_level_full;
1700: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1701: l_rel_tbl1 csi_datastructures_pub.ii_relationship_tbl;
1702: l_msg_count number;
1703: l_msg_data varchar2(240);
1704: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1705: l_depth NUMBER := null;

Line 1706: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

1702: l_msg_count number;
1703: l_msg_data varchar2(240);
1704: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1705: l_depth NUMBER := null;
1706: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
1707: l_relationship_query_rec1 csi_datastructures_pub.relationship_query_rec;
1708: l_all_parents_id varchar2(4000);
1709: l_time_stamp DATE := p_time_stamp;
1710: l_active_relationship_only VARCHAR2(1) := fnd_api.g_true; --fix for bug5222952

Line 1707: l_relationship_query_rec1 csi_datastructures_pub.relationship_query_rec;

1703: l_msg_data varchar2(240);
1704: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1705: l_depth NUMBER := null;
1706: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
1707: l_relationship_query_rec1 csi_datastructures_pub.relationship_query_rec;
1708: l_all_parents_id varchar2(4000);
1709: l_time_stamp DATE := p_time_stamp;
1710: l_active_relationship_only VARCHAR2(1) := fnd_api.g_true; --fix for bug5222952
1711: l_var integer;

Line 1811: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

1807: l_api_version number := 1.0;
1808: l_commit varchar2(1) := fnd_api.g_false;
1809: l_init_msg_list varchar2(1) := fnd_api.g_false;
1810: l_validation_level number := fnd_api.g_valid_level_full;
1811: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1812: l_msg_count number;
1813: l_msg_data varchar2(240);
1814: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1815: l_depth NUMBER := null;

Line 1816: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

1812: l_msg_count number;
1813: l_msg_data varchar2(240);
1814: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1815: l_depth NUMBER := null;
1816: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
1817: l_all_parents_id varchar2(4000);
1818: l_time_stamp DATE :=p_time_stamp;
1819: l_active_relationship_only VARCHAR2(1) := fnd_api.g_false;
1820: l_output varchar2(4000);

Line 1987: ,x_contact_details OUT NOCOPY csi_datastructures_pub.contact_details_rec

1983: ,p_validation_level IN NUMBER
1984: ,p_contact_party_id IN NUMBER
1985: ,p_contact_flag IN VARCHAR2
1986: ,p_party_tbl IN VARCHAR2
1987: ,x_contact_details OUT NOCOPY csi_datastructures_pub.contact_details_rec
1988: ,x_return_status OUT NOCOPY VARCHAR2
1989: ,x_msg_count OUT NOCOPY NUMBER
1990: ,x_msg_data OUT NOCOPY VARCHAR2
1991: )

Line 2059: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2055: ,p_commit IN VARCHAR2
2056: ,p_init_msg_list IN VARCHAR2
2057: ,p_validation_level IN NUMBER
2058: ,p_subject_id IN NUMBER
2059: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2060: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
2061: ,x_return_status OUT NOCOPY VARCHAR2
2062: ,x_msg_count OUT NOCOPY NUMBER
2063: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2060: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

2056: ,p_init_msg_list IN VARCHAR2
2057: ,p_validation_level IN NUMBER
2058: ,p_subject_id IN NUMBER
2059: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2060: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
2061: ,x_return_status OUT NOCOPY VARCHAR2
2062: ,x_msg_count OUT NOCOPY NUMBER
2063: ,x_msg_data OUT NOCOPY VARCHAR2
2064: ) IS

Line 2067: l_relationship_rec csi_datastructures_pub.ii_relationship_rec;

2063: ,x_msg_data OUT NOCOPY VARCHAR2
2064: ) IS
2065: l_relationship_id NUMBER;
2066: l_object_version_number NUMBER;
2067: l_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2068: BEGIN
2069: SELECT
2070: relationship_id, object_version_number INTO l_relationship_id, l_object_version_number
2071: FROM