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 264: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec

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

Line 273: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

Line 274: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

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

Line 359: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

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

Line 368: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

Line 369: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec

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

Line 453: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

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

Line 460: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

Line 461: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

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

Line 1053: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl

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

Line 1054: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl

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

Line 1055: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl

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

Line 1056: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl

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

Line 1057: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl

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

Line 1058: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl

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

Line 1059: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl

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

Line 1060: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl

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

Line 1068: temp_instance_history_tbl csi_datastructures_pub.instance_history_tbl;

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

Line 1069: temp_ins_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;

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

Line 1070: temp_party_history_tbl csi_datastructures_pub.party_history_tbl;

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

Line 1071: temp_account_history_tbl csi_datastructures_pub.account_history_tbl;

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

Line 1072: temp_org_unit_history_tbl csi_datastructures_pub.org_units_history_tbl;

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

Line 1073: temp_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;

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

Line 1074: temp_rel_history_tbl csi_datastructures_pub.relationship_history_tbl;

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

Line 1551: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec

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

Line 1560: --l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

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

Line 1622: p_rel_tbl1 in csi_datastructures_pub.ii_relationship_tbl,

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

Line 1701: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

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

Line 1702: l_rel_tbl1 csi_datastructures_pub.ii_relationship_tbl;

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

Line 1707: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

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

Line 1708: l_relationship_query_rec1 csi_datastructures_pub.relationship_query_rec;

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

Line 1812: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

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

Line 1817: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

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

Line 1988: ,x_contact_details OUT NOCOPY csi_datastructures_pub.contact_details_rec

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

Line 2060: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

Line 2061: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

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

Line 2068: l_relationship_rec csi_datastructures_pub.ii_relationship_rec;

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