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

Line 13: p_rel_glbl_tbl csi_datastructures_pub.ii_relationship_tbl;

9:
10:
11: g_pkg_name CONSTANT VARCHAR2(30) := 'csi_ii_relationships_pvt';
12: g_file_name CONSTANT VARCHAR2(12) := 'csiviirb.pls';
13: p_rel_glbl_tbl csi_datastructures_pub.ii_relationship_tbl;
14: p_glbl_ctr NUMBER := 0;
15:
16: p_ii_rel_level_glbl_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl; --bug 10321217
17:

Line 38: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

34: p_instance_id IN NUMBER ,
35: p_depth IN NUMBER,
36: p_time_stamp IN DATE,
37: p_active_relationship_only IN VARCHAR2,
38: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
39: x_return_status OUT NOCOPY VARCHAR2,
40: x_msg_count OUT NOCOPY NUMBER,
41: x_msg_data OUT NOCOPY VARCHAR2
42: )

Line 259: x_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl)

255: PROCEDURE get_rel_for_instance
256: (p_instance_id IN NUMBER,
257: p_time_stamp IN DATE,
258: p_active_relationship_only IN VARCHAR2,
259: x_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl)
260: IS
261:
262: l_cur_instance_id NUMBER;
263: i NUMBER;

Line 462: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,

458: PROCEDURE validate_ii_relationships(
459: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
460: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
461: p_validation_mode IN VARCHAR2,
462: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_msg_count OUT NOCOPY NUMBER,
465: x_msg_data OUT NOCOPY VARCHAR2
466: );

Line 518: p_relations_rec IN csi_datastructures_pub.ii_relationship_rec,

514: );
515:
516:
517: PROCEDURE define_columns(
518: p_relations_rec IN csi_datastructures_pub.ii_relationship_rec,
519: p_cur_get_relations IN NUMBER
520: )
521: IS
522: BEGIN

Line 559: x_rel_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec

555:
556:
557: PROCEDURE get_column_values(
558: p_cur_get_relations IN NUMBER,
559: x_rel_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
560: )
561: IS
562: BEGIN
563: DBMS_SQL.COLUMN_VALUE(p_cur_get_relations, 1, x_rel_rec.relationship_id);

Line 595: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,

591: END get_column_values;
592:
593:
594: PROCEDURE bind(
595: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
596: p_cur_get_relations IN NUMBER
597: )
598: IS
599: BEGIN

Line 626: p_relship_query_rec IN csi_datastructures_pub.relationship_query_rec,

622: END bind;
623:
624:
625: PROCEDURE gen_select(
626: p_relship_query_rec IN csi_datastructures_pub.relationship_query_rec,
627: x_select_cl OUT NOCOPY VARCHAR2
628: )
629: IS
630: l_table_name VARCHAR2(30);

Line 643: p_relship_query_rec IN csi_datastructures_pub.relationship_query_rec,

639:
640: END gen_select;
641:
642: PROCEDURE gen_relations_where(
643: p_relship_query_rec IN csi_datastructures_pub.relationship_query_rec,
644: p_active_relationship_only IN VARCHAR2,
645: p_depth IN NUMBER,
646: x_relations_where OUT NOCOPY VARCHAR2
647: )

Line 817: PROCEDURE get_history( p_rel_rec IN csi_datastructures_pub.ii_relationship_rec

813: END IF;
814: END;
815:
816:
817: PROCEDURE get_history( p_rel_rec IN csi_datastructures_pub.ii_relationship_rec
818: ,p_new_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
819: ,p_flag OUT NOCOPY VARCHAR2
820: ,p_time_stamp IN DATE
821: )

Line 818: ,p_new_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec

814: END;
815:
816:
817: PROCEDURE get_history( p_rel_rec IN csi_datastructures_pub.ii_relationship_rec
818: ,p_new_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
819: ,p_flag OUT NOCOPY VARCHAR2
820: ,p_time_stamp IN DATE
821: )
822: IS

Line 1143: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

1139: END;
1140:
1141: PROCEDURE Get_Next_Level
1142: (p_object_id IN NUMBER,
1143: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
1144: ) IS
1145: --
1146: CURSOR REL_CUR IS
1147: select relationship_id,relationship_type_code,object_id,subject_id,position_reference,

Line 1191: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

1187:
1188:
1189: PROCEDURE Get_Children
1190: (p_object_id IN NUMBER,
1191: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
1192: ) IS
1193: --
1194: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1195: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;

Line 1194: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

1190: (p_object_id IN NUMBER,
1191: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
1192: ) IS
1193: --
1194: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1195: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1196: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1197: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1198: l_next_ind NUMBER := 0;

Line 1195: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;

1191: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
1192: ) IS
1193: --
1194: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1195: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1196: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1197: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1198: l_next_ind NUMBER := 0;
1199: l_final_ind NUMBER := 0;

Line 1196: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;

1192: ) IS
1193: --
1194: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1195: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1196: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1197: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1198: l_next_ind NUMBER := 0;
1199: l_final_ind NUMBER := 0;
1200: l_ctr NUMBER := 0;

Line 1197: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;

1193: --
1194: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1195: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1196: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1197: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1198: l_next_ind NUMBER := 0;
1199: l_final_ind NUMBER := 0;
1200: l_ctr NUMBER := 0;
1201: l_found NUMBER;

Line 1257: p_rel_tbl IN csi_datastructures_pub.ii_relationship_tbl

1253: END Get_Children;
1254: --
1255: FUNCTION Parent_of
1256: ( p_subject_id IN NUMBER,
1257: p_rel_tbl IN csi_datastructures_pub.ii_relationship_tbl
1258: ) RETURN NUMBER IS
1259: l_return_value NUMBER := -9999;
1260: BEGIN
1261: IF p_rel_tbl.count = 0 OR

Line 1278: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

1274: PROCEDURE Get_Next_Level
1275: (p_object_id IN NUMBER,
1276: p_relationship_id IN NUMBER,
1277: p_subject_id IN NUMBER,
1278: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
1279: p_rel_type_code IN VARCHAR2,
1280: p_time_stamp IN DATE,
1281: p_active_relationship_only IN VARCHAR2,
1282: p_active_instances_only IN VARCHAR2,

Line 1688: (p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,

1684: END Get_Next_Level;
1685: --
1686:
1687: PROCEDURE DFS
1688: (p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
1689: p_active_relationship_only IN VARCHAR2,
1690: p_active_instances_only IN VARCHAR2,
1691: p_config_only IN VARCHAR2,
1692: p_curr_level IN NUMBER := 1, --bug 10321217

Line 1695: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;

1691: p_config_only IN VARCHAR2,
1692: p_curr_level IN NUMBER := 1, --bug 10321217
1693: p_depth_req IN NUMBER := 9999 --bug 10321217
1694: ) IS
1695: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1696: l_time_stamp DATE;
1697: BEGIN
1698: p_glbl_ctr := p_glbl_ctr + 1;
1699:

Line 1761: (p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,

1757: END DFS;
1758:
1759:
1760: PROCEDURE Get_Children
1761: (p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
1762: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
1763: p_depth IN NUMBER,
1764: p_active_relationship_only IN VARCHAR2,
1765: p_active_instances_only IN VARCHAR2,

Line 1762: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

1758:
1759:
1760: PROCEDURE Get_Children
1761: (p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
1762: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
1763: p_depth IN NUMBER,
1764: p_active_relationship_only IN VARCHAR2,
1765: p_active_instances_only IN VARCHAR2,
1766: p_config_only IN VARCHAR2, -- if true will retrieve instances with config keys

Line 1777: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

1773: ) IS
1774: --
1775: l_api_name CONSTANT VARCHAR2(30) := 'get_children';
1776: l_api_version CONSTANT NUMBER := 1.0;
1777: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1778: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1779: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1780: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1781: l_next_ind NUMBER := 0;

Line 1778: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;

1774: --
1775: l_api_name CONSTANT VARCHAR2(30) := 'get_children';
1776: l_api_version CONSTANT NUMBER := 1.0;
1777: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1778: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1779: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1780: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1781: l_next_ind NUMBER := 0;
1782: l_final_ind NUMBER := 0;

Line 1779: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;

1775: l_api_name CONSTANT VARCHAR2(30) := 'get_children';
1776: l_api_version CONSTANT NUMBER := 1.0;
1777: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1778: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1779: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1780: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1781: l_next_ind NUMBER := 0;
1782: l_final_ind NUMBER := 0;
1783: l_ctr NUMBER := 0;

Line 1780: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;

1776: l_api_version CONSTANT NUMBER := 1.0;
1777: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1778: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1779: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1780: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1781: l_next_ind NUMBER := 0;
1782: l_final_ind NUMBER := 0;
1783: l_ctr NUMBER := 0;
1784: l_temp_id NUMBER;

Line 2079: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

2075:
2076: PROCEDURE Get_Immediate_Parents
2077: ( p_subject_id IN NUMBER,
2078: p_rel_type_code IN VARCHAR2,
2079: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
2080: ) IS
2081: l_ctr NUMBER := 0;
2082: l_object_id NUMBER;
2083: l_subject_id NUMBER;

Line 2137: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,

2133: p_api_version IN NUMBER,
2134: p_commit IN VARCHAR2,
2135: p_init_msg_list IN VARCHAR2,
2136: p_validation_level IN NUMBER,
2137: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
2138: p_depth IN NUMBER,
2139: p_time_stamp IN DATE,
2140: p_active_relationship_only IN VARCHAR2,
2141: p_recursive_flag IN VARCHAR2,

Line 2142: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

2138: p_depth IN NUMBER,
2139: p_time_stamp IN DATE,
2140: p_active_relationship_only IN VARCHAR2,
2141: p_recursive_flag IN VARCHAR2,
2142: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
2143: x_return_status OUT NOCOPY VARCHAR2,
2144: x_msg_count OUT NOCOPY NUMBER,
2145: x_msg_data OUT NOCOPY VARCHAR2
2146: )

Line 2159: l_rel_rec csi_datastructures_pub.ii_relationship_rec;

2155: l_access_flag VARCHAR2(1);
2156: i NUMBER := 1;
2157: l_instance_id NUMBER;
2158: l_returned_rec_count NUMBER := 0;
2159: l_rel_rec csi_datastructures_pub.ii_relationship_rec;
2160: l_debug_level NUMBER;
2161: l_new_rec csi_datastructures_pub.ii_relationship_rec;
2162: l_flag VARCHAR2(4);
2163: l_active_relationship_only VARCHAR2(1) := p_active_relationship_only;

Line 2161: l_new_rec csi_datastructures_pub.ii_relationship_rec;

2157: l_instance_id NUMBER;
2158: l_returned_rec_count NUMBER := 0;
2159: l_rel_rec csi_datastructures_pub.ii_relationship_rec;
2160: l_debug_level NUMBER;
2161: l_new_rec csi_datastructures_pub.ii_relationship_rec;
2162: l_flag VARCHAR2(4);
2163: l_active_relationship_only VARCHAR2(1) := p_active_relationship_only;
2164: l_depth NUMBER;
2165: l_found VARCHAR2(1); -- Added by sguthiva for bug 2373109

Line 2166: xc_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;

2162: l_flag VARCHAR2(4);
2163: l_active_relationship_only VARCHAR2(1) := p_active_relationship_only;
2164: l_depth NUMBER;
2165: l_found VARCHAR2(1); -- Added by sguthiva for bug 2373109
2166: xc_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2167: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2168: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;
2169: l_rel_count NUMBER := 0;
2170: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 2167: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;

2163: l_active_relationship_only VARCHAR2(1) := p_active_relationship_only;
2164: l_depth NUMBER;
2165: l_found VARCHAR2(1); -- Added by sguthiva for bug 2373109
2166: xc_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2167: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2168: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;
2169: l_rel_count NUMBER := 0;
2170: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2171: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 2168: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;

2164: l_depth NUMBER;
2165: l_found VARCHAR2(1); -- Added by sguthiva for bug 2373109
2166: xc_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2167: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2168: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;
2169: l_rel_count NUMBER := 0;
2170: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2171: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
2172: l_ctr NUMBER;

Line 2170: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

2166: xc_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2167: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2168: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;
2169: l_rel_count NUMBER := 0;
2170: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2171: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
2172: l_ctr NUMBER;
2173: l_exists VARCHAR2(1);
2174: l_exists_flag VARCHAR2(1);

Line 2171: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

2167: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2168: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;
2169: l_rel_count NUMBER := 0;
2170: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2171: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
2172: l_ctr NUMBER;
2173: l_exists VARCHAR2(1);
2174: l_exists_flag VARCHAR2(1);
2175: l_msg_index NUMBER;

Line 2181: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;

2177: l_last_purge_date DATE;
2178: TYPE NUMLIST IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2179: l_exp_inst_tbl NUMLIST;
2180: --
2181: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
2182: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2183: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2184: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2185: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 2182: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;

2178: TYPE NUMLIST IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2179: l_exp_inst_tbl NUMLIST;
2180: --
2181: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
2182: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2183: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2184: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2185: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2186: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 2183: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;

2179: l_exp_inst_tbl NUMLIST;
2180: --
2181: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
2182: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2183: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2184: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2185: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2186: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2187: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;

Line 2184: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;

2180: --
2181: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
2182: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2183: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2184: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2185: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2186: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2187: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
2188: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;

Line 2185: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

2181: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
2182: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2183: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2184: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2185: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2186: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2187: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
2188: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
2189: --

Line 2186: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

2182: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2183: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2184: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2185: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2186: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2187: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
2188: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
2189: --
2190: /*

Line 2187: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;

2183: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2184: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2185: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2186: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2187: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
2188: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
2189: --
2190: /*
2191: CURSOR CHILD_CUR(p_instance_id IN NUMBER) IS

Line 2188: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;

2184: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2185: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2186: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2187: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
2188: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
2189: --
2190: /*
2191: CURSOR CHILD_CUR(p_instance_id IN NUMBER) IS
2192: SELECT subject_id

Line 2209: l_exp_tbl csi_datastructures_pub.ii_relationship_tbl;

2205: CONNECT BY object_id = PRIOR subject_id;
2206: */
2207: l_fin_count NUMBER;
2208: l_fin_count1 NUMBER;
2209: l_exp_tbl csi_datastructures_pub.ii_relationship_tbl;
2210: l_temp_tbl csi_datastructures_pub.ii_relationship_tbl;
2211: l_exp_act_tbl csi_datastructures_pub.ii_relationship_tbl;
2212: l_found1 BOOLEAN;
2213: l_found2 BOOLEAN;

Line 2210: l_temp_tbl csi_datastructures_pub.ii_relationship_tbl;

2206: */
2207: l_fin_count NUMBER;
2208: l_fin_count1 NUMBER;
2209: l_exp_tbl csi_datastructures_pub.ii_relationship_tbl;
2210: l_temp_tbl csi_datastructures_pub.ii_relationship_tbl;
2211: l_exp_act_tbl csi_datastructures_pub.ii_relationship_tbl;
2212: l_found1 BOOLEAN;
2213: l_found2 BOOLEAN;
2214: l_expire BOOLEAN;

Line 2211: l_exp_act_tbl csi_datastructures_pub.ii_relationship_tbl;

2207: l_fin_count NUMBER;
2208: l_fin_count1 NUMBER;
2209: l_exp_tbl csi_datastructures_pub.ii_relationship_tbl;
2210: l_temp_tbl csi_datastructures_pub.ii_relationship_tbl;
2211: l_exp_act_tbl csi_datastructures_pub.ii_relationship_tbl;
2212: l_found1 BOOLEAN;
2213: l_found2 BOOLEAN;
2214: l_expire BOOLEAN;
2215: l_exp_count NUMBER:=0;

Line 2216: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

2212: l_found1 BOOLEAN;
2213: l_found2 BOOLEAN;
2214: l_expire BOOLEAN;
2215: l_exp_count NUMBER:=0;
2216: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
2217: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
2218:
2219: BEGIN
2220: -- standard start of api savepoint

Line 3453: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

3449: x_msg_count OUT NOCOPY NUMBER,
3450: x_msg_data OUT NOCOPY VARCHAR2
3451: )
3452: IS
3453: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
3454: p_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
3455: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
3456: /* CURSOR chk_obj_csr IS
3457: SELECT 'x'

Line 3454: p_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

3450: x_msg_data OUT NOCOPY VARCHAR2
3451: )
3452: IS
3453: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
3454: p_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
3455: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
3456: /* CURSOR chk_obj_csr IS
3457: SELECT 'x'
3458: FROM csi_ii_relationships

Line 3513: PROCEDURE validate_history(p_old_relship_rec IN csi_datastructures_pub.ii_relationship_rec,

3509: x_return_status := fnd_api.g_ret_sts_error;
3510: END IF;
3511: END check_for_object;
3512:
3513: PROCEDURE validate_history(p_old_relship_rec IN csi_datastructures_pub.ii_relationship_rec,
3514: p_new_relship_rec IN csi_datastructures_pub.ii_relationship_rec,
3515: p_transaction_id IN NUMBER,
3516: p_flag IN VARCHAR2,
3517: p_sysdate IN DATE,

Line 3514: p_new_relship_rec IN csi_datastructures_pub.ii_relationship_rec,

3510: END IF;
3511: END check_for_object;
3512:
3513: PROCEDURE validate_history(p_old_relship_rec IN csi_datastructures_pub.ii_relationship_rec,
3514: p_new_relship_rec IN csi_datastructures_pub.ii_relationship_rec,
3515: p_transaction_id IN NUMBER,
3516: p_flag IN VARCHAR2,
3517: p_sysdate IN DATE,
3518: x_return_status OUT NOCOPY VARCHAR2,

Line 3522: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_old_relship_rec;

3518: x_return_status OUT NOCOPY VARCHAR2,
3519: x_msg_count OUT NOCOPY NUMBER,
3520: x_msg_data OUT NOCOPY VARCHAR2)
3521: IS
3522: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_old_relship_rec;
3523: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_new_relship_rec;
3524: l_transaction_id NUMBER := p_transaction_id;
3525: l_full_dump NUMBER;
3526: l_relship_hist_rec csi_datastructures_pub.relationship_history_rec;

Line 3523: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_new_relship_rec;

3519: x_msg_count OUT NOCOPY NUMBER,
3520: x_msg_data OUT NOCOPY VARCHAR2)
3521: IS
3522: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_old_relship_rec;
3523: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_new_relship_rec;
3524: l_transaction_id NUMBER := p_transaction_id;
3525: l_full_dump NUMBER;
3526: l_relship_hist_rec csi_datastructures_pub.relationship_history_rec;
3527:

Line 3526: l_relship_hist_rec csi_datastructures_pub.relationship_history_rec;

3522: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_old_relship_rec;
3523: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_new_relship_rec;
3524: l_transaction_id NUMBER := p_transaction_id;
3525: l_full_dump NUMBER;
3526: l_relship_hist_rec csi_datastructures_pub.relationship_history_rec;
3527:
3528: CURSOR rel_hist_csr (p_rel_hist_id NUMBER) IS
3529: SELECT relationship_history_id
3530: ,relationship_id

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

3584:
3585:
3586: x_return_status := fnd_api.g_ret_sts_success;
3587: --
3588: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3589: csi_gen_utility_pvt.populate_install_param_rec;
3590: END IF;
3591: --
3592: l_full_dump := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;

Line 3592: l_full_dump := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;

3588: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3589: csi_gen_utility_pvt.populate_install_param_rec;
3590: END IF;
3591: --
3592: l_full_dump := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
3593: --
3594: IF l_full_dump IS NULL THEN
3595: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
3596: FND_MSG_PUB.ADD;

Line 4397: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,

4393: ( p_api_version IN NUMBER,
4394: p_commit IN VARCHAR2,
4395: p_init_msg_list IN VARCHAR2,
4396: p_validation_level IN NUMBER,
4397: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
4398: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4399: p_mode IN VARCHAR2,
4400: x_return_status OUT NOCOPY VARCHAR2,
4401: x_msg_count OUT NOCOPY NUMBER,

Line 4398: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4394: p_commit IN VARCHAR2,
4395: p_init_msg_list IN VARCHAR2,
4396: p_validation_level IN NUMBER,
4397: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
4398: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4399: p_mode IN VARCHAR2,
4400: x_return_status OUT NOCOPY VARCHAR2,
4401: x_msg_count OUT NOCOPY NUMBER,
4402: x_msg_data OUT NOCOPY VARCHAR2)

Line 4411: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;

4407: FROM csi_ii_relationships
4408: START WITH subject_id = p_subject_id
4409: CONNECT BY subject_id = PRIOR object_id; */
4410:
4411: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4412: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4413: l_party_tbl csi_datastructures_pub.party_tbl;
4414: l_account_tbl csi_datastructures_pub.party_account_tbl;
4415: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4412: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4408: START WITH subject_id = p_subject_id
4409: CONNECT BY subject_id = PRIOR object_id; */
4410:
4411: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4412: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4413: l_party_tbl csi_datastructures_pub.party_tbl;
4414: l_account_tbl csi_datastructures_pub.party_account_tbl;
4415: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4416: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4413: l_party_tbl csi_datastructures_pub.party_tbl;

4409: CONNECT BY subject_id = PRIOR object_id; */
4410:
4411: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4412: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4413: l_party_tbl csi_datastructures_pub.party_tbl;
4414: l_account_tbl csi_datastructures_pub.party_account_tbl;
4415: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4416: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4417: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4414: l_account_tbl csi_datastructures_pub.party_account_tbl;

4410:
4411: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4412: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4413: l_party_tbl csi_datastructures_pub.party_tbl;
4414: l_account_tbl csi_datastructures_pub.party_account_tbl;
4415: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4416: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4417: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4418: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4415: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4411: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4412: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4413: l_party_tbl csi_datastructures_pub.party_tbl;
4414: l_account_tbl csi_datastructures_pub.party_account_tbl;
4415: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4416: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4417: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4418: l_instance_id_lst csi_datastructures_pub.id_tbl;
4419: l_instance_rec csi_datastructures_pub.instance_rec;

Line 4416: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4412: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4413: l_party_tbl csi_datastructures_pub.party_tbl;
4414: l_account_tbl csi_datastructures_pub.party_account_tbl;
4415: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4416: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4417: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4418: l_instance_id_lst csi_datastructures_pub.id_tbl;
4419: l_instance_rec csi_datastructures_pub.instance_rec;
4420: l_instance_rec1 csi_datastructures_pub.instance_rec;

Line 4417: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

4413: l_party_tbl csi_datastructures_pub.party_tbl;
4414: l_account_tbl csi_datastructures_pub.party_account_tbl;
4415: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4416: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4417: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4418: l_instance_id_lst csi_datastructures_pub.id_tbl;
4419: l_instance_rec csi_datastructures_pub.instance_rec;
4420: l_instance_rec1 csi_datastructures_pub.instance_rec;
4421: l_temp_ins_rec csi_datastructures_pub.instance_rec;

Line 4418: l_instance_id_lst csi_datastructures_pub.id_tbl;

4414: l_account_tbl csi_datastructures_pub.party_account_tbl;
4415: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4416: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4417: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4418: l_instance_id_lst csi_datastructures_pub.id_tbl;
4419: l_instance_rec csi_datastructures_pub.instance_rec;
4420: l_instance_rec1 csi_datastructures_pub.instance_rec;
4421: l_temp_ins_rec csi_datastructures_pub.instance_rec;
4422: l_dummy NUMBER;

Line 4419: l_instance_rec csi_datastructures_pub.instance_rec;

4415: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4416: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4417: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4418: l_instance_id_lst csi_datastructures_pub.id_tbl;
4419: l_instance_rec csi_datastructures_pub.instance_rec;
4420: l_instance_rec1 csi_datastructures_pub.instance_rec;
4421: l_temp_ins_rec csi_datastructures_pub.instance_rec;
4422: l_dummy NUMBER;
4423: l_object_version NUMBER;

Line 4420: l_instance_rec1 csi_datastructures_pub.instance_rec;

4416: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4417: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4418: l_instance_id_lst csi_datastructures_pub.id_tbl;
4419: l_instance_rec csi_datastructures_pub.instance_rec;
4420: l_instance_rec1 csi_datastructures_pub.instance_rec;
4421: l_temp_ins_rec csi_datastructures_pub.instance_rec;
4422: l_dummy NUMBER;
4423: l_object_version NUMBER;
4424: l_object_version1 NUMBER;

Line 4421: l_temp_ins_rec csi_datastructures_pub.instance_rec;

4417: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4418: l_instance_id_lst csi_datastructures_pub.id_tbl;
4419: l_instance_rec csi_datastructures_pub.instance_rec;
4420: l_instance_rec1 csi_datastructures_pub.instance_rec;
4421: l_temp_ins_rec csi_datastructures_pub.instance_rec;
4422: l_dummy NUMBER;
4423: l_object_version NUMBER;
4424: l_object_version1 NUMBER;
4425: l_subject_id NUMBER;

Line 4431: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

4427: l_location_tbl csi_item_instance_pvt.location_tbl;
4428: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4429: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4430: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
4431: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
4432: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
4433: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
4434: -- Begin Add Code for Siebel Genesis Project
4435: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4435: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4431: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
4432: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
4433: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
4434: -- Begin Add Code for Siebel Genesis Project
4435: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4436: p_party_tbl csi_datastructures_pub.party_tbl;
4437: p_account_tbl csi_datastructures_pub.party_account_tbl;
4438: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4439: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4436: p_party_tbl csi_datastructures_pub.party_tbl;

4432: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
4433: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
4434: -- Begin Add Code for Siebel Genesis Project
4435: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4436: p_party_tbl csi_datastructures_pub.party_tbl;
4437: p_account_tbl csi_datastructures_pub.party_account_tbl;
4438: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4439: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4440: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4437: p_account_tbl csi_datastructures_pub.party_account_tbl;

4433: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
4434: -- Begin Add Code for Siebel Genesis Project
4435: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4436: p_party_tbl csi_datastructures_pub.party_tbl;
4437: p_account_tbl csi_datastructures_pub.party_account_tbl;
4438: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4439: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4440: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4441: -- End Add Code for Siebel Genesis Project

Line 4438: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4434: -- Begin Add Code for Siebel Genesis Project
4435: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4436: p_party_tbl csi_datastructures_pub.party_tbl;
4437: p_account_tbl csi_datastructures_pub.party_account_tbl;
4438: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4439: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4440: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4441: -- End Add Code for Siebel Genesis Project
4442:

Line 4439: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4435: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4436: p_party_tbl csi_datastructures_pub.party_tbl;
4437: p_account_tbl csi_datastructures_pub.party_account_tbl;
4438: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4439: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4440: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4441: -- End Add Code for Siebel Genesis Project
4442:
4443: BEGIN

Line 4440: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

4436: p_party_tbl csi_datastructures_pub.party_tbl;
4437: p_account_tbl csi_datastructures_pub.party_account_tbl;
4438: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4439: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4440: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4441: -- End Add Code for Siebel Genesis Project
4442:
4443: BEGIN
4444:

Line 4690: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,

4686: ( p_api_version IN NUMBER,
4687: p_commit IN VARCHAR2,
4688: p_init_msg_list IN VARCHAR2,
4689: p_validation_level IN NUMBER,
4690: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
4691: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4692: x_return_status OUT NOCOPY VARCHAR2,
4693: x_msg_count OUT NOCOPY NUMBER,
4694: x_msg_data OUT NOCOPY VARCHAR2)

Line 4691: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4687: p_commit IN VARCHAR2,
4688: p_init_msg_list IN VARCHAR2,
4689: p_validation_level IN NUMBER,
4690: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
4691: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4692: x_return_status OUT NOCOPY VARCHAR2,
4693: x_msg_count OUT NOCOPY NUMBER,
4694: x_msg_data OUT NOCOPY VARCHAR2)
4695: IS

Line 4696: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4692: x_return_status OUT NOCOPY VARCHAR2,
4693: x_msg_count OUT NOCOPY NUMBER,
4694: x_msg_data OUT NOCOPY VARCHAR2)
4695: IS
4696: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4697: l_party_tbl csi_datastructures_pub.party_tbl;
4698: l_account_tbl csi_datastructures_pub.party_account_tbl;
4699: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4700: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4697: l_party_tbl csi_datastructures_pub.party_tbl;

4693: x_msg_count OUT NOCOPY NUMBER,
4694: x_msg_data OUT NOCOPY VARCHAR2)
4695: IS
4696: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4697: l_party_tbl csi_datastructures_pub.party_tbl;
4698: l_account_tbl csi_datastructures_pub.party_account_tbl;
4699: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4700: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4701: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4698: l_account_tbl csi_datastructures_pub.party_account_tbl;

4694: x_msg_data OUT NOCOPY VARCHAR2)
4695: IS
4696: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4697: l_party_tbl csi_datastructures_pub.party_tbl;
4698: l_account_tbl csi_datastructures_pub.party_account_tbl;
4699: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4700: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4701: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4702: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4699: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4695: IS
4696: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4697: l_party_tbl csi_datastructures_pub.party_tbl;
4698: l_account_tbl csi_datastructures_pub.party_account_tbl;
4699: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4700: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4701: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4702: l_instance_id_lst csi_datastructures_pub.id_tbl;
4703: l_instance_rec csi_datastructures_pub.instance_rec;

Line 4700: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4696: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4697: l_party_tbl csi_datastructures_pub.party_tbl;
4698: l_account_tbl csi_datastructures_pub.party_account_tbl;
4699: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4700: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4701: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4702: l_instance_id_lst csi_datastructures_pub.id_tbl;
4703: l_instance_rec csi_datastructures_pub.instance_rec;
4704: l_subject_id NUMBER;

Line 4701: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

4697: l_party_tbl csi_datastructures_pub.party_tbl;
4698: l_account_tbl csi_datastructures_pub.party_account_tbl;
4699: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4700: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4701: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4702: l_instance_id_lst csi_datastructures_pub.id_tbl;
4703: l_instance_rec csi_datastructures_pub.instance_rec;
4704: l_subject_id NUMBER;
4705: l_record_found VARCHAR2(1):= fnd_api.g_true;

Line 4702: l_instance_id_lst csi_datastructures_pub.id_tbl;

4698: l_account_tbl csi_datastructures_pub.party_account_tbl;
4699: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4700: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4701: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4702: l_instance_id_lst csi_datastructures_pub.id_tbl;
4703: l_instance_rec csi_datastructures_pub.instance_rec;
4704: l_subject_id NUMBER;
4705: l_record_found VARCHAR2(1):= fnd_api.g_true;
4706: BEGIN

Line 4703: l_instance_rec csi_datastructures_pub.instance_rec;

4699: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4700: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4701: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4702: l_instance_id_lst csi_datastructures_pub.id_tbl;
4703: l_instance_rec csi_datastructures_pub.instance_rec;
4704: l_subject_id NUMBER;
4705: l_record_found VARCHAR2(1):= fnd_api.g_true;
4706: BEGIN
4707: IF p_ii_relationship_rec.relationship_type_code='COMPONENT-OF' THEN

Line 4809: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

4805: p_api_version IN NUMBER,
4806: p_commit IN VARCHAR2,
4807: p_init_msg_list IN VARCHAR2,
4808: p_validation_level IN NUMBER,
4809: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4810: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4811: x_return_status OUT NOCOPY VARCHAR2,
4812: x_msg_count OUT NOCOPY NUMBER,
4813: x_msg_data OUT NOCOPY VARCHAR2

Line 4810: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4806: p_commit IN VARCHAR2,
4807: p_init_msg_list IN VARCHAR2,
4808: p_validation_level IN NUMBER,
4809: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4810: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4811: x_return_status OUT NOCOPY VARCHAR2,
4812: x_msg_count OUT NOCOPY NUMBER,
4813: x_msg_data OUT NOCOPY VARCHAR2
4814: )

Line 4822: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;

4818: l_api_name CONSTANT VARCHAR2(30) := 'create_relationship';
4819: l_api_version CONSTANT NUMBER := 1.0;
4820: l_return_status_full VARCHAR2(1);
4821: l_access_flag VARCHAR2(1);
4822: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4823: l_line_count NUMBER;
4824: l_relationship_id NUMBER;
4825: l_debug_level NUMBER;
4826: l_relship_history_id NUMBER;

Line 4833: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4829: l_msg_count NUMBER; -- Added by sguthiva for bug 2373109
4830: l_exists VARCHAR2(1);
4831:
4832: -- Added for cascade ownership change bug 2972082
4833: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4834: l_party_tbl csi_datastructures_pub.party_tbl;
4835: l_account_tbl csi_datastructures_pub.party_account_tbl;
4836: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4837: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

Line 4834: l_party_tbl csi_datastructures_pub.party_tbl;

4830: l_exists VARCHAR2(1);
4831:
4832: -- Added for cascade ownership change bug 2972082
4833: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4834: l_party_tbl csi_datastructures_pub.party_tbl;
4835: l_account_tbl csi_datastructures_pub.party_account_tbl;
4836: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4837: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4838: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4835: l_account_tbl csi_datastructures_pub.party_account_tbl;

4831:
4832: -- Added for cascade ownership change bug 2972082
4833: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4834: l_party_tbl csi_datastructures_pub.party_tbl;
4835: l_account_tbl csi_datastructures_pub.party_account_tbl;
4836: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4837: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4838: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4839: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4836: l_temp_party_tbl csi_datastructures_pub.party_tbl;

4832: -- Added for cascade ownership change bug 2972082
4833: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4834: l_party_tbl csi_datastructures_pub.party_tbl;
4835: l_account_tbl csi_datastructures_pub.party_account_tbl;
4836: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4837: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4838: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4839: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4840: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4837: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

4833: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4834: l_party_tbl csi_datastructures_pub.party_tbl;
4835: l_account_tbl csi_datastructures_pub.party_account_tbl;
4836: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4837: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4838: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4839: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4840: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4841: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4838: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4834: l_party_tbl csi_datastructures_pub.party_tbl;
4835: l_account_tbl csi_datastructures_pub.party_account_tbl;
4836: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4837: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4838: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4839: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4840: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4841: l_instance_id_lst csi_datastructures_pub.id_tbl;
4842: l_instance_rec csi_datastructures_pub.instance_rec;

Line 4839: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4835: l_account_tbl csi_datastructures_pub.party_account_tbl;
4836: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4837: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4838: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4839: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4840: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4841: l_instance_id_lst csi_datastructures_pub.id_tbl;
4842: l_instance_rec csi_datastructures_pub.instance_rec;
4843: l_cascade_instance_rec csi_datastructures_pub.instance_rec;

Line 4840: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

4836: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4837: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4838: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4839: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4840: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4841: l_instance_id_lst csi_datastructures_pub.id_tbl;
4842: l_instance_rec csi_datastructures_pub.instance_rec;
4843: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
4844: -- End addition for cascade ownership changes bug 2972082

Line 4841: l_instance_id_lst csi_datastructures_pub.id_tbl;

4837: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4838: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4839: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4840: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4841: l_instance_id_lst csi_datastructures_pub.id_tbl;
4842: l_instance_rec csi_datastructures_pub.instance_rec;
4843: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
4844: -- End addition for cascade ownership changes bug 2972082
4845:

Line 4842: l_instance_rec csi_datastructures_pub.instance_rec;

4838: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4839: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4840: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4841: l_instance_id_lst csi_datastructures_pub.id_tbl;
4842: l_instance_rec csi_datastructures_pub.instance_rec;
4843: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
4844: -- End addition for cascade ownership changes bug 2972082
4845:
4846: BEGIN

Line 4843: l_cascade_instance_rec csi_datastructures_pub.instance_rec;

4839: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4840: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4841: l_instance_id_lst csi_datastructures_pub.id_tbl;
4842: l_instance_rec csi_datastructures_pub.instance_rec;
4843: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
4844: -- End addition for cascade ownership changes bug 2972082
4845:
4846: BEGIN
4847: -- standard start of api savepoint

Line 5342: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,

5338: p_api_version IN NUMBER,
5339: p_commit IN VARCHAR2,
5340: p_init_msg_list IN VARCHAR2,
5341: p_validation_level IN NUMBER,
5342: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
5343: p_replace_flag IN VARCHAR2,
5344: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5345: x_return_status OUT NOCOPY VARCHAR2,
5346: x_msg_count OUT NOCOPY NUMBER,

Line 5344: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

5340: p_init_msg_list IN VARCHAR2,
5341: p_validation_level IN NUMBER,
5342: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
5343: p_replace_flag IN VARCHAR2,
5344: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5345: x_return_status OUT NOCOPY VARCHAR2,
5346: x_msg_count OUT NOCOPY NUMBER,
5347: x_msg_data OUT NOCOPY VARCHAR2
5348: ) IS

Line 5391: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;

5387: l_count NUMBER;
5388: l_debug_level NUMBER;
5389: l_line_count NUMBER;
5390: l_relship_csr relship_csr%ROWTYPE;
5391: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
5392: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
5393: l_instance_rec csi_datastructures_pub.instance_rec;
5394: l_temp_ins_rec csi_datastructures_pub.instance_rec;
5395: l_object_id NUMBER;

Line 5392: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;

5388: l_debug_level NUMBER;
5389: l_line_count NUMBER;
5390: l_relship_csr relship_csr%ROWTYPE;
5391: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
5392: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
5393: l_instance_rec csi_datastructures_pub.instance_rec;
5394: l_temp_ins_rec csi_datastructures_pub.instance_rec;
5395: l_object_id NUMBER;
5396: l_obv_number NUMBER;

Line 5393: l_instance_rec csi_datastructures_pub.instance_rec;

5389: l_line_count NUMBER;
5390: l_relship_csr relship_csr%ROWTYPE;
5391: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
5392: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
5393: l_instance_rec csi_datastructures_pub.instance_rec;
5394: l_temp_ins_rec csi_datastructures_pub.instance_rec;
5395: l_object_id NUMBER;
5396: l_obv_number NUMBER;
5397: l_ins_usage_code VARCHAR2(30);

Line 5394: l_temp_ins_rec csi_datastructures_pub.instance_rec;

5390: l_relship_csr relship_csr%ROWTYPE;
5391: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
5392: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
5393: l_instance_rec csi_datastructures_pub.instance_rec;
5394: l_temp_ins_rec csi_datastructures_pub.instance_rec;
5395: l_object_id NUMBER;
5396: l_obv_number NUMBER;
5397: l_ins_usage_code VARCHAR2(30);
5398: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 5398: l_instance_id_lst csi_datastructures_pub.id_tbl;

5394: l_temp_ins_rec csi_datastructures_pub.instance_rec;
5395: l_object_id NUMBER;
5396: l_obv_number NUMBER;
5397: l_ins_usage_code VARCHAR2(30);
5398: l_instance_id_lst csi_datastructures_pub.id_tbl;
5399: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5400: l_location_tbl csi_item_instance_pvt.location_tbl;
5401: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5402: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

Line 5404: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

5400: l_location_tbl csi_item_instance_pvt.location_tbl;
5401: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5402: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5403: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5404: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
5405: l_obj_id NUMBER;
5406: l_sub_id NUMBER;
5407: l_msg_data VARCHAR2(2000);
5408: l_msg_index NUMBER;

Line 5413: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

5409: l_msg_count NUMBER;
5410: l_found BOOLEAN;
5411: l_exists VARCHAR2(1);
5412: -- Added for cascade ownership change bug 2972082
5413: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
5414: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5415: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5416: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5417: l_party_tbl csi_datastructures_pub.party_tbl;

Line 5414: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

5410: l_found BOOLEAN;
5411: l_exists VARCHAR2(1);
5412: -- Added for cascade ownership change bug 2972082
5413: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
5414: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5415: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5416: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5417: l_party_tbl csi_datastructures_pub.party_tbl;
5418: l_account_tbl csi_datastructures_pub.party_account_tbl;

Line 5416: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5412: -- Added for cascade ownership change bug 2972082
5413: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
5414: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5415: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5416: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5417: l_party_tbl csi_datastructures_pub.party_tbl;
5418: l_account_tbl csi_datastructures_pub.party_account_tbl;
5419: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5420: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

Line 5417: l_party_tbl csi_datastructures_pub.party_tbl;

5413: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
5414: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5415: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5416: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5417: l_party_tbl csi_datastructures_pub.party_tbl;
5418: l_account_tbl csi_datastructures_pub.party_account_tbl;
5419: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5420: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5421: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 5418: l_account_tbl csi_datastructures_pub.party_account_tbl;

5414: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5415: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5416: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5417: l_party_tbl csi_datastructures_pub.party_tbl;
5418: l_account_tbl csi_datastructures_pub.party_account_tbl;
5419: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5420: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5421: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5422: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 5419: l_temp_party_tbl csi_datastructures_pub.party_tbl;

5415: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5416: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5417: l_party_tbl csi_datastructures_pub.party_tbl;
5418: l_account_tbl csi_datastructures_pub.party_account_tbl;
5419: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5420: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5421: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5422: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5423: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 5420: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

5416: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5417: l_party_tbl csi_datastructures_pub.party_tbl;
5418: l_account_tbl csi_datastructures_pub.party_account_tbl;
5419: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5420: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5421: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5422: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5423: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5424: l_inst_id_lst csi_datastructures_pub.id_tbl;

Line 5421: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

5417: l_party_tbl csi_datastructures_pub.party_tbl;
5418: l_account_tbl csi_datastructures_pub.party_account_tbl;
5419: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5420: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5421: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5422: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5423: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5424: l_inst_id_lst csi_datastructures_pub.id_tbl;
5425: l_inst_rec csi_datastructures_pub.instance_rec;

Line 5422: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

5418: l_account_tbl csi_datastructures_pub.party_account_tbl;
5419: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5420: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5421: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5422: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5423: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5424: l_inst_id_lst csi_datastructures_pub.id_tbl;
5425: l_inst_rec csi_datastructures_pub.instance_rec;
5426: l_cascade_instance_rec csi_datastructures_pub.instance_rec;

Line 5423: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

5419: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5420: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5421: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5422: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5423: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5424: l_inst_id_lst csi_datastructures_pub.id_tbl;
5425: l_inst_rec csi_datastructures_pub.instance_rec;
5426: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
5427: l_item_id NUMBER;

Line 5424: l_inst_id_lst csi_datastructures_pub.id_tbl;

5420: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5421: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5422: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5423: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5424: l_inst_id_lst csi_datastructures_pub.id_tbl;
5425: l_inst_rec csi_datastructures_pub.instance_rec;
5426: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
5427: l_item_id NUMBER;
5428: l_srl_ctl NUMBER;

Line 5425: l_inst_rec csi_datastructures_pub.instance_rec;

5421: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5422: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5423: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5424: l_inst_id_lst csi_datastructures_pub.id_tbl;
5425: l_inst_rec csi_datastructures_pub.instance_rec;
5426: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
5427: l_item_id NUMBER;
5428: l_srl_ctl NUMBER;
5429: l_vld_org NUMBER;

Line 5426: l_cascade_instance_rec csi_datastructures_pub.instance_rec;

5422: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5423: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5424: l_inst_id_lst csi_datastructures_pub.id_tbl;
5425: l_inst_rec csi_datastructures_pub.instance_rec;
5426: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
5427: l_item_id NUMBER;
5428: l_srl_ctl NUMBER;
5429: l_vld_org NUMBER;
5430: l_loc_type_code VARCHAR2(30);

Line 6223: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,

6219: p_api_version IN NUMBER,
6220: p_commit IN VARCHAR2,
6221: p_init_msg_list IN VARCHAR2,
6222: p_validation_level IN NUMBER,
6223: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
6224: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6225: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
6226: x_return_status OUT NOCOPY VARCHAR2,
6227: x_msg_count OUT NOCOPY NUMBER,

Line 6224: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

6220: p_commit IN VARCHAR2,
6221: p_init_msg_list IN VARCHAR2,
6222: p_validation_level IN NUMBER,
6223: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
6224: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6225: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
6226: x_return_status OUT NOCOPY VARCHAR2,
6227: x_msg_count OUT NOCOPY NUMBER,
6228: x_msg_data OUT NOCOPY VARCHAR2

Line 6225: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,

6221: p_init_msg_list IN VARCHAR2,
6222: p_validation_level IN NUMBER,
6223: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
6224: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6225: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
6226: x_return_status OUT NOCOPY VARCHAR2,
6227: x_msg_count OUT NOCOPY NUMBER,
6228: x_msg_data OUT NOCOPY VARCHAR2
6229: ) IS

Line 6266: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;

6262: l_relship_csr relship_csr%ROWTYPE;
6263: l_api_name CONSTANT VARCHAR2(30) := 'expire_relationship';
6264: l_api_version CONSTANT NUMBER := 1.0;
6265: l_debug_level NUMBER;
6266: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
6267: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_sysdate CONSTANT DATE :=SYSDATE;
6270: l_instance_rec csi_datastructures_pub.instance_rec;

Line 6267: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;

6263: l_api_name CONSTANT VARCHAR2(30) := 'expire_relationship';
6264: l_api_version CONSTANT NUMBER := 1.0;
6265: l_debug_level NUMBER;
6266: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
6267: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_sysdate CONSTANT DATE :=SYSDATE;
6270: l_instance_rec csi_datastructures_pub.instance_rec;
6271: l_temp_ins_rec csi_datastructures_pub.instance_rec;

Line 6268: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

6264: l_api_version CONSTANT NUMBER := 1.0;
6265: l_debug_level NUMBER;
6266: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
6267: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_sysdate CONSTANT DATE :=SYSDATE;
6270: l_instance_rec csi_datastructures_pub.instance_rec;
6271: l_temp_ins_rec csi_datastructures_pub.instance_rec;
6272: l_object_id NUMBER;

Line 6270: l_instance_rec csi_datastructures_pub.instance_rec;

6266: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
6267: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_sysdate CONSTANT DATE :=SYSDATE;
6270: l_instance_rec csi_datastructures_pub.instance_rec;
6271: l_temp_ins_rec csi_datastructures_pub.instance_rec;
6272: l_object_id NUMBER;
6273: l_obv_number NUMBER;
6274: l_ins_usage_code VARCHAR2(30);

Line 6271: l_temp_ins_rec csi_datastructures_pub.instance_rec;

6267: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_sysdate CONSTANT DATE :=SYSDATE;
6270: l_instance_rec csi_datastructures_pub.instance_rec;
6271: l_temp_ins_rec csi_datastructures_pub.instance_rec;
6272: l_object_id NUMBER;
6273: l_obv_number NUMBER;
6274: l_ins_usage_code VARCHAR2(30);
6275: l_instance_status_id NUMBER;

Line 6276: l_instance_id_lst csi_datastructures_pub.id_tbl;

6272: l_object_id NUMBER;
6273: l_obv_number NUMBER;
6274: l_ins_usage_code VARCHAR2(30);
6275: l_instance_status_id NUMBER;
6276: l_instance_id_lst csi_datastructures_pub.id_tbl;
6277: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6278: l_location_tbl csi_item_instance_pvt.location_tbl;
6279: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6280: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

Line 7287: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,

7283: PROCEDURE validate_ii_relationships(
7284: p_init_msg_list IN VARCHAR2,
7285: p_validation_level IN NUMBER,
7286: p_validation_mode IN VARCHAR2,
7287: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
7288: x_return_status OUT NOCOPY VARCHAR2,
7289: x_msg_count OUT NOCOPY NUMBER,
7290: x_msg_data OUT NOCOPY VARCHAR2
7291: )

Line 7388: (p_rel_history_tbl IN OUT NOCOPY csi_datastructures_pub.relationship_history_tbl)

7384: /* id columns */
7385: /*----------------------------------------------------------*/
7386:
7387: PROCEDURE Resolve_id_columns
7388: (p_rel_history_tbl IN OUT NOCOPY csi_datastructures_pub.relationship_history_tbl)
7389: IS
7390:
7391: BEGIN
7392: IF p_rel_history_tbl.count > 0 THEN

Line 7452: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl

7448: ,p_commit IN VARCHAR2 := fnd_api.g_false
7449: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
7450: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
7451: ,p_transaction_id IN NUMBER
7452: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl
7453: ,x_return_status OUT NOCOPY VARCHAR2
7454: ,x_msg_count OUT NOCOPY NUMBER
7455: ,x_msg_data OUT NOCOPY VARCHAR2
7456: )IS

Line 7463: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;

7459: l_api_version CONSTANT NUMBER := 1.0 ;
7460: l_csi_debug_level NUMBER ;
7461: l_flag VARCHAR2(1) :='N' ;
7462: i NUMBER :=1 ;
7463: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
7464: l_time_stamp DATE ;
7465: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
7466:
7467: CURSOR get_relationship_hist(i_transaction_id NUMBER)

Line 7465: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;

7461: l_flag VARCHAR2(1) :='N' ;
7462: i NUMBER :=1 ;
7463: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
7464: l_time_stamp DATE ;
7465: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
7466:
7467: CURSOR get_relationship_hist(i_transaction_id NUMBER)
7468: IS
7469: SELECT

Line 7739: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

7735: /*-------------------------------------------------------------------*/
7736: PROCEDURE Get_Cyclic_Node
7737: ( p_instance_id IN NUMBER,
7738: p_cyclic_node OUT NOCOPY NUMBER,
7739: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
7740: p_stop_at_cyclic IN VARCHAR2,
7741: x_return_status OUT NOCOPY VARCHAR2,
7742: x_msg_count OUT NOCOPY NUMBER,
7743: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 7757: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;

7753: l_msg_index NUMBER;
7754: l_msg_count NUMBER;
7755: l_debug_level NUMBER;
7756: l_adj_node NUMBER;
7757: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
7758: l_api_name CONSTANT VARCHAR2(50) := 'get_cyclic_node';
7759: --
7760: l_rel_color_tbl csi_ii_relationships_pvt.REL_COLOR_TBL;
7761: l_rel_color_ctr NUMBER := 0;