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 33: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

29: p_instance_id IN NUMBER ,
30: p_depth IN NUMBER,
31: p_time_stamp IN DATE,
32: p_active_relationship_only IN VARCHAR2,
33: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2
37: )

Line 252: x_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl)

248: PROCEDURE get_rel_for_instance
249: (p_instance_id IN NUMBER,
250: p_time_stamp IN DATE,
251: p_active_relationship_only IN VARCHAR2,
252: x_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl)
253: IS
254:
255: l_cur_instance_id NUMBER;
256: i NUMBER;

Line 455: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,

451: PROCEDURE validate_ii_relationships(
452: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
453: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
454: p_validation_mode IN VARCHAR2,
455: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
456: x_return_status OUT NOCOPY VARCHAR2,
457: x_msg_count OUT NOCOPY NUMBER,
458: x_msg_data OUT NOCOPY VARCHAR2
459: );

Line 511: p_relations_rec IN csi_datastructures_pub.ii_relationship_rec,

507: );
508:
509:
510: PROCEDURE define_columns(
511: p_relations_rec IN csi_datastructures_pub.ii_relationship_rec,
512: p_cur_get_relations IN NUMBER
513: )
514: IS
515: BEGIN

Line 552: x_rel_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec

548:
549:
550: PROCEDURE get_column_values(
551: p_cur_get_relations IN NUMBER,
552: x_rel_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
553: )
554: IS
555: BEGIN
556: DBMS_SQL.COLUMN_VALUE(p_cur_get_relations, 1, x_rel_rec.relationship_id);

Line 588: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,

584: END get_column_values;
585:
586:
587: PROCEDURE bind(
588: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
589: p_cur_get_relations IN NUMBER
590: )
591: IS
592: BEGIN

Line 619: p_relship_query_rec IN csi_datastructures_pub.relationship_query_rec,

615: END bind;
616:
617:
618: PROCEDURE gen_select(
619: p_relship_query_rec IN csi_datastructures_pub.relationship_query_rec,
620: x_select_cl OUT NOCOPY VARCHAR2
621: )
622: IS
623: l_table_name VARCHAR2(30);

Line 636: p_relship_query_rec IN csi_datastructures_pub.relationship_query_rec,

632:
633: END gen_select;
634:
635: PROCEDURE gen_relations_where(
636: p_relship_query_rec IN csi_datastructures_pub.relationship_query_rec,
637: p_active_relationship_only IN VARCHAR2,
638: p_depth IN NUMBER,
639: x_relations_where OUT NOCOPY VARCHAR2
640: )

Line 810: PROCEDURE get_history( p_rel_rec IN csi_datastructures_pub.ii_relationship_rec

806: END IF;
807: END;
808:
809:
810: PROCEDURE get_history( p_rel_rec IN csi_datastructures_pub.ii_relationship_rec
811: ,p_new_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
812: ,p_flag OUT NOCOPY VARCHAR2
813: ,p_time_stamp IN DATE
814: )

Line 811: ,p_new_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec

807: END;
808:
809:
810: PROCEDURE get_history( p_rel_rec IN csi_datastructures_pub.ii_relationship_rec
811: ,p_new_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
812: ,p_flag OUT NOCOPY VARCHAR2
813: ,p_time_stamp IN DATE
814: )
815: IS

Line 1136: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

1132: END;
1133:
1134: PROCEDURE Get_Next_Level
1135: (p_object_id IN NUMBER,
1136: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
1137: ) IS
1138: --
1139: CURSOR REL_CUR IS
1140: select relationship_id,relationship_type_code,object_id,subject_id,position_reference,

Line 1184: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

1180:
1181:
1182: PROCEDURE Get_Children
1183: (p_object_id IN NUMBER,
1184: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
1185: ) IS
1186: --
1187: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1188: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;

Line 1187: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

1183: (p_object_id IN NUMBER,
1184: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
1185: ) IS
1186: --
1187: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1188: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1189: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1190: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1191: l_next_ind NUMBER := 0;

Line 1188: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;

1184: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
1185: ) IS
1186: --
1187: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1188: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1189: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1190: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1191: l_next_ind NUMBER := 0;
1192: l_final_ind NUMBER := 0;

Line 1189: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;

1185: ) IS
1186: --
1187: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1188: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1189: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1190: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1191: l_next_ind NUMBER := 0;
1192: l_final_ind NUMBER := 0;
1193: l_ctr NUMBER := 0;

Line 1190: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;

1186: --
1187: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1188: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1189: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1190: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1191: l_next_ind NUMBER := 0;
1192: l_final_ind NUMBER := 0;
1193: l_ctr NUMBER := 0;
1194: l_found NUMBER;

Line 1250: p_rel_tbl IN csi_datastructures_pub.ii_relationship_tbl

1246: END Get_Children;
1247: --
1248: FUNCTION Parent_of
1249: ( p_subject_id IN NUMBER,
1250: p_rel_tbl IN csi_datastructures_pub.ii_relationship_tbl
1251: ) RETURN NUMBER IS
1252: l_return_value NUMBER := -9999;
1253: BEGIN
1254: IF p_rel_tbl.count = 0 OR

Line 1271: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

1267: PROCEDURE Get_Next_Level
1268: (p_object_id IN NUMBER,
1269: p_relationship_id IN NUMBER,
1270: p_subject_id IN NUMBER,
1271: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
1272: p_rel_type_code IN VARCHAR2,
1273: p_time_stamp IN DATE,
1274: p_active_relationship_only IN VARCHAR2,
1275: p_active_instances_only IN VARCHAR2,

Line 1680: (p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,

1676: NULL;
1677: END Get_Next_Level;
1678: --
1679: PROCEDURE Get_Children
1680: (p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
1681: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
1682: p_depth IN NUMBER,
1683: p_active_relationship_only IN VARCHAR2,
1684: p_active_instances_only IN VARCHAR2,

Line 1681: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

1677: END Get_Next_Level;
1678: --
1679: PROCEDURE Get_Children
1680: (p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
1681: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
1682: p_depth IN NUMBER,
1683: p_active_relationship_only IN VARCHAR2,
1684: p_active_instances_only IN VARCHAR2,
1685: p_config_only IN VARCHAR2, -- if true will retrieve instances with config keys

Line 1696: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

1692: ) IS
1693: --
1694: l_api_name CONSTANT VARCHAR2(30) := 'get_children';
1695: l_api_version CONSTANT NUMBER := 1.0;
1696: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1697: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1698: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1699: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1700: l_next_ind NUMBER := 0;

Line 1697: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;

1693: --
1694: l_api_name CONSTANT VARCHAR2(30) := 'get_children';
1695: l_api_version CONSTANT NUMBER := 1.0;
1696: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1697: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1698: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1699: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1700: l_next_ind NUMBER := 0;
1701: l_final_ind NUMBER := 0;

Line 1698: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;

1694: l_api_name CONSTANT VARCHAR2(30) := 'get_children';
1695: l_api_version CONSTANT NUMBER := 1.0;
1696: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1697: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1698: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1699: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1700: l_next_ind NUMBER := 0;
1701: l_final_ind NUMBER := 0;
1702: l_ctr NUMBER := 0;

Line 1699: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;

1695: l_api_version CONSTANT NUMBER := 1.0;
1696: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1697: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
1698: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
1699: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
1700: l_next_ind NUMBER := 0;
1701: l_final_ind NUMBER := 0;
1702: l_ctr NUMBER := 0;
1703: l_temp_id NUMBER;

Line 1954: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

1950:
1951: PROCEDURE Get_Immediate_Parents
1952: ( p_subject_id IN NUMBER,
1953: p_rel_type_code IN VARCHAR2,
1954: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
1955: ) IS
1956: l_ctr NUMBER := 0;
1957: l_object_id NUMBER;
1958: l_subject_id NUMBER;

Line 2012: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,

2008: p_api_version IN NUMBER,
2009: p_commit IN VARCHAR2,
2010: p_init_msg_list IN VARCHAR2,
2011: p_validation_level IN NUMBER,
2012: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
2013: p_depth IN NUMBER,
2014: p_time_stamp IN DATE,
2015: p_active_relationship_only IN VARCHAR2,
2016: p_recursive_flag IN VARCHAR2,

Line 2017: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

2013: p_depth IN NUMBER,
2014: p_time_stamp IN DATE,
2015: p_active_relationship_only IN VARCHAR2,
2016: p_recursive_flag IN VARCHAR2,
2017: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
2018: x_return_status OUT NOCOPY VARCHAR2,
2019: x_msg_count OUT NOCOPY NUMBER,
2020: x_msg_data OUT NOCOPY VARCHAR2
2021: )

Line 2034: l_rel_rec csi_datastructures_pub.ii_relationship_rec;

2030: l_access_flag VARCHAR2(1);
2031: i NUMBER := 1;
2032: l_instance_id NUMBER;
2033: l_returned_rec_count NUMBER := 0;
2034: l_rel_rec csi_datastructures_pub.ii_relationship_rec;
2035: l_debug_level NUMBER;
2036: l_new_rec csi_datastructures_pub.ii_relationship_rec;
2037: l_flag VARCHAR2(4);
2038: l_active_relationship_only VARCHAR2(1) := p_active_relationship_only;

Line 2036: l_new_rec csi_datastructures_pub.ii_relationship_rec;

2032: l_instance_id NUMBER;
2033: l_returned_rec_count NUMBER := 0;
2034: l_rel_rec csi_datastructures_pub.ii_relationship_rec;
2035: l_debug_level NUMBER;
2036: l_new_rec csi_datastructures_pub.ii_relationship_rec;
2037: l_flag VARCHAR2(4);
2038: l_active_relationship_only VARCHAR2(1) := p_active_relationship_only;
2039: l_depth NUMBER;
2040: l_found VARCHAR2(1); -- Added by sguthiva for bug 2373109

Line 2041: xc_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;

2037: l_flag VARCHAR2(4);
2038: l_active_relationship_only VARCHAR2(1) := p_active_relationship_only;
2039: l_depth NUMBER;
2040: l_found VARCHAR2(1); -- Added by sguthiva for bug 2373109
2041: xc_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2042: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2043: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;
2044: l_rel_count NUMBER := 0;
2045: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 2042: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;

2038: l_active_relationship_only VARCHAR2(1) := p_active_relationship_only;
2039: l_depth NUMBER;
2040: l_found VARCHAR2(1); -- Added by sguthiva for bug 2373109
2041: xc_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2042: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2043: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;
2044: l_rel_count NUMBER := 0;
2045: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2046: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 2043: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;

2039: l_depth NUMBER;
2040: l_found VARCHAR2(1); -- Added by sguthiva for bug 2373109
2041: xc_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2042: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2043: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;
2044: l_rel_count NUMBER := 0;
2045: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2046: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
2047: l_ctr NUMBER;

Line 2045: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

2041: xc_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2042: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2043: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;
2044: l_rel_count NUMBER := 0;
2045: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2046: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
2047: l_ctr NUMBER;
2048: l_exists VARCHAR2(1);
2049: l_exists_flag VARCHAR2(1);

Line 2046: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

2042: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
2043: l_ins_child_tbl csi_datastructures_pub.ii_relationship_tbl ;
2044: l_rel_count NUMBER := 0;
2045: l_temp_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2046: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
2047: l_ctr NUMBER;
2048: l_exists VARCHAR2(1);
2049: l_exists_flag VARCHAR2(1);
2050: l_msg_index NUMBER;

Line 2056: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;

2052: l_last_purge_date DATE;
2053: TYPE NUMLIST IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2054: l_exp_inst_tbl NUMLIST;
2055: --
2056: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
2057: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2058: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2059: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 2057: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;

2053: TYPE NUMLIST IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2054: l_exp_inst_tbl NUMLIST;
2055: --
2056: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
2057: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2058: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2059: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2061: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 2058: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;

2054: l_exp_inst_tbl NUMLIST;
2055: --
2056: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
2057: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2058: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2059: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2061: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2062: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;

Line 2059: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;

2055: --
2056: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
2057: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2058: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2059: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2061: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2062: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
2063: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;

Line 2060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

2056: l_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
2057: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2058: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2059: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2061: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2062: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
2063: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
2064: --

Line 2061: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

2057: l_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
2058: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2059: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2061: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2062: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
2063: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
2064: --
2065: /*

Line 2062: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;

2058: l_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
2059: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2061: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2062: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
2063: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
2064: --
2065: /*
2066: CURSOR CHILD_CUR(p_instance_id IN NUMBER) IS

Line 2063: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;

2059: l_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
2060: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
2061: l_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
2062: l_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
2063: l_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
2064: --
2065: /*
2066: CURSOR CHILD_CUR(p_instance_id IN NUMBER) IS
2067: SELECT subject_id

Line 2084: l_exp_tbl csi_datastructures_pub.ii_relationship_tbl;

2080: CONNECT BY object_id = PRIOR subject_id;
2081: */
2082: l_fin_count NUMBER;
2083: l_fin_count1 NUMBER;
2084: l_exp_tbl csi_datastructures_pub.ii_relationship_tbl;
2085: l_temp_tbl csi_datastructures_pub.ii_relationship_tbl;
2086: l_exp_act_tbl csi_datastructures_pub.ii_relationship_tbl;
2087: l_found1 BOOLEAN;
2088: l_found2 BOOLEAN;

Line 2085: l_temp_tbl csi_datastructures_pub.ii_relationship_tbl;

2081: */
2082: l_fin_count NUMBER;
2083: l_fin_count1 NUMBER;
2084: l_exp_tbl csi_datastructures_pub.ii_relationship_tbl;
2085: l_temp_tbl csi_datastructures_pub.ii_relationship_tbl;
2086: l_exp_act_tbl csi_datastructures_pub.ii_relationship_tbl;
2087: l_found1 BOOLEAN;
2088: l_found2 BOOLEAN;
2089: l_expire BOOLEAN;

Line 2086: l_exp_act_tbl csi_datastructures_pub.ii_relationship_tbl;

2082: l_fin_count NUMBER;
2083: l_fin_count1 NUMBER;
2084: l_exp_tbl csi_datastructures_pub.ii_relationship_tbl;
2085: l_temp_tbl csi_datastructures_pub.ii_relationship_tbl;
2086: l_exp_act_tbl csi_datastructures_pub.ii_relationship_tbl;
2087: l_found1 BOOLEAN;
2088: l_found2 BOOLEAN;
2089: l_expire BOOLEAN;
2090: l_exp_count NUMBER:=0;

Line 2091: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

2087: l_found1 BOOLEAN;
2088: l_found2 BOOLEAN;
2089: l_expire BOOLEAN;
2090: l_exp_count NUMBER:=0;
2091: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
2092: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
2093:
2094: BEGIN
2095: -- standard start of api savepoint

Line 3305: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

3301: x_msg_count OUT NOCOPY NUMBER,
3302: x_msg_data OUT NOCOPY VARCHAR2
3303: )
3304: IS
3305: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
3306: p_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
3307: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
3308: /* CURSOR chk_obj_csr IS
3309: SELECT 'x'

Line 3306: p_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

3302: x_msg_data OUT NOCOPY VARCHAR2
3303: )
3304: IS
3305: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
3306: p_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
3307: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
3308: /* CURSOR chk_obj_csr IS
3309: SELECT 'x'
3310: FROM csi_ii_relationships

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

3361: x_return_status := fnd_api.g_ret_sts_error;
3362: END IF;
3363: END check_for_object;
3364:
3365: PROCEDURE validate_history(p_old_relship_rec IN csi_datastructures_pub.ii_relationship_rec,
3366: p_new_relship_rec IN csi_datastructures_pub.ii_relationship_rec,
3367: p_transaction_id IN NUMBER,
3368: p_flag IN VARCHAR2,
3369: p_sysdate IN DATE,

Line 3366: p_new_relship_rec IN csi_datastructures_pub.ii_relationship_rec,

3362: END IF;
3363: END check_for_object;
3364:
3365: PROCEDURE validate_history(p_old_relship_rec IN csi_datastructures_pub.ii_relationship_rec,
3366: p_new_relship_rec IN csi_datastructures_pub.ii_relationship_rec,
3367: p_transaction_id IN NUMBER,
3368: p_flag IN VARCHAR2,
3369: p_sysdate IN DATE,
3370: x_return_status OUT NOCOPY VARCHAR2,

Line 3374: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_old_relship_rec;

3370: x_return_status OUT NOCOPY VARCHAR2,
3371: x_msg_count OUT NOCOPY NUMBER,
3372: x_msg_data OUT NOCOPY VARCHAR2)
3373: IS
3374: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_old_relship_rec;
3375: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_new_relship_rec;
3376: l_transaction_id NUMBER := p_transaction_id;
3377: l_full_dump NUMBER;
3378: l_relship_hist_rec csi_datastructures_pub.relationship_history_rec;

Line 3375: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_new_relship_rec;

3371: x_msg_count OUT NOCOPY NUMBER,
3372: x_msg_data OUT NOCOPY VARCHAR2)
3373: IS
3374: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_old_relship_rec;
3375: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_new_relship_rec;
3376: l_transaction_id NUMBER := p_transaction_id;
3377: l_full_dump NUMBER;
3378: l_relship_hist_rec csi_datastructures_pub.relationship_history_rec;
3379:

Line 3378: l_relship_hist_rec csi_datastructures_pub.relationship_history_rec;

3374: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_old_relship_rec;
3375: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec :=p_new_relship_rec;
3376: l_transaction_id NUMBER := p_transaction_id;
3377: l_full_dump NUMBER;
3378: l_relship_hist_rec csi_datastructures_pub.relationship_history_rec;
3379:
3380: CURSOR rel_hist_csr (p_rel_hist_id NUMBER) IS
3381: SELECT relationship_history_id
3382: ,relationship_id

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

3436:
3437:
3438: x_return_status := fnd_api.g_ret_sts_success;
3439: --
3440: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3441: csi_gen_utility_pvt.populate_install_param_rec;
3442: END IF;
3443: --
3444: l_full_dump := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;

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

3440: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3441: csi_gen_utility_pvt.populate_install_param_rec;
3442: END IF;
3443: --
3444: l_full_dump := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
3445: --
3446: IF l_full_dump IS NULL THEN
3447: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
3448: FND_MSG_PUB.ADD;

Line 4247: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,

4243: ( p_api_version IN NUMBER,
4244: p_commit IN VARCHAR2,
4245: p_init_msg_list IN VARCHAR2,
4246: p_validation_level IN NUMBER,
4247: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
4248: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4249: p_mode IN VARCHAR2,
4250: x_return_status OUT NOCOPY VARCHAR2,
4251: x_msg_count OUT NOCOPY NUMBER,

Line 4248: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4244: p_commit IN VARCHAR2,
4245: p_init_msg_list IN VARCHAR2,
4246: p_validation_level IN NUMBER,
4247: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
4248: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4249: p_mode IN VARCHAR2,
4250: x_return_status OUT NOCOPY VARCHAR2,
4251: x_msg_count OUT NOCOPY NUMBER,
4252: x_msg_data OUT NOCOPY VARCHAR2)

Line 4261: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;

4257: FROM csi_ii_relationships
4258: START WITH subject_id = p_subject_id
4259: CONNECT BY subject_id = PRIOR object_id; */
4260:
4261: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4262: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4263: l_party_tbl csi_datastructures_pub.party_tbl;
4264: l_account_tbl csi_datastructures_pub.party_account_tbl;
4265: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4262: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4258: START WITH subject_id = p_subject_id
4259: CONNECT BY subject_id = PRIOR object_id; */
4260:
4261: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4262: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4263: l_party_tbl csi_datastructures_pub.party_tbl;
4264: l_account_tbl csi_datastructures_pub.party_account_tbl;
4265: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4266: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4263: l_party_tbl csi_datastructures_pub.party_tbl;

4259: CONNECT BY subject_id = PRIOR object_id; */
4260:
4261: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4262: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4263: l_party_tbl csi_datastructures_pub.party_tbl;
4264: l_account_tbl csi_datastructures_pub.party_account_tbl;
4265: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4266: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4267: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4264: l_account_tbl csi_datastructures_pub.party_account_tbl;

4260:
4261: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4262: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4263: l_party_tbl csi_datastructures_pub.party_tbl;
4264: l_account_tbl csi_datastructures_pub.party_account_tbl;
4265: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4266: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4267: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4268: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4265: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4261: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4262: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4263: l_party_tbl csi_datastructures_pub.party_tbl;
4264: l_account_tbl csi_datastructures_pub.party_account_tbl;
4265: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4266: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4267: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4268: l_instance_id_lst csi_datastructures_pub.id_tbl;
4269: l_instance_rec csi_datastructures_pub.instance_rec;

Line 4266: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4262: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4263: l_party_tbl csi_datastructures_pub.party_tbl;
4264: l_account_tbl csi_datastructures_pub.party_account_tbl;
4265: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4266: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4267: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4268: l_instance_id_lst csi_datastructures_pub.id_tbl;
4269: l_instance_rec csi_datastructures_pub.instance_rec;
4270: l_instance_rec1 csi_datastructures_pub.instance_rec;

Line 4267: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

4263: l_party_tbl csi_datastructures_pub.party_tbl;
4264: l_account_tbl csi_datastructures_pub.party_account_tbl;
4265: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4266: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4267: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4268: l_instance_id_lst csi_datastructures_pub.id_tbl;
4269: l_instance_rec csi_datastructures_pub.instance_rec;
4270: l_instance_rec1 csi_datastructures_pub.instance_rec;
4271: l_temp_ins_rec csi_datastructures_pub.instance_rec;

Line 4268: l_instance_id_lst csi_datastructures_pub.id_tbl;

4264: l_account_tbl csi_datastructures_pub.party_account_tbl;
4265: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4266: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4267: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4268: l_instance_id_lst csi_datastructures_pub.id_tbl;
4269: l_instance_rec csi_datastructures_pub.instance_rec;
4270: l_instance_rec1 csi_datastructures_pub.instance_rec;
4271: l_temp_ins_rec csi_datastructures_pub.instance_rec;
4272: l_dummy NUMBER;

Line 4269: l_instance_rec csi_datastructures_pub.instance_rec;

4265: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4266: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4267: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4268: l_instance_id_lst csi_datastructures_pub.id_tbl;
4269: l_instance_rec csi_datastructures_pub.instance_rec;
4270: l_instance_rec1 csi_datastructures_pub.instance_rec;
4271: l_temp_ins_rec csi_datastructures_pub.instance_rec;
4272: l_dummy NUMBER;
4273: l_object_version NUMBER;

Line 4270: l_instance_rec1 csi_datastructures_pub.instance_rec;

4266: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4267: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4268: l_instance_id_lst csi_datastructures_pub.id_tbl;
4269: l_instance_rec csi_datastructures_pub.instance_rec;
4270: l_instance_rec1 csi_datastructures_pub.instance_rec;
4271: l_temp_ins_rec csi_datastructures_pub.instance_rec;
4272: l_dummy NUMBER;
4273: l_object_version NUMBER;
4274: l_object_version1 NUMBER;

Line 4271: l_temp_ins_rec csi_datastructures_pub.instance_rec;

4267: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4268: l_instance_id_lst csi_datastructures_pub.id_tbl;
4269: l_instance_rec csi_datastructures_pub.instance_rec;
4270: l_instance_rec1 csi_datastructures_pub.instance_rec;
4271: l_temp_ins_rec csi_datastructures_pub.instance_rec;
4272: l_dummy NUMBER;
4273: l_object_version NUMBER;
4274: l_object_version1 NUMBER;
4275: l_subject_id NUMBER;

Line 4281: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

4277: l_location_tbl csi_item_instance_pvt.location_tbl;
4278: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4279: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4280: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
4281: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
4282: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
4283: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
4284: -- Begin Add Code for Siebel Genesis Project
4285: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4285: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4281: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
4282: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
4283: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
4284: -- Begin Add Code for Siebel Genesis Project
4285: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4286: p_party_tbl csi_datastructures_pub.party_tbl;
4287: p_account_tbl csi_datastructures_pub.party_account_tbl;
4288: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4289: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4286: p_party_tbl csi_datastructures_pub.party_tbl;

4282: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
4283: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
4284: -- Begin Add Code for Siebel Genesis Project
4285: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4286: p_party_tbl csi_datastructures_pub.party_tbl;
4287: p_account_tbl csi_datastructures_pub.party_account_tbl;
4288: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4289: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4290: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4287: p_account_tbl csi_datastructures_pub.party_account_tbl;

4283: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
4284: -- Begin Add Code for Siebel Genesis Project
4285: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4286: p_party_tbl csi_datastructures_pub.party_tbl;
4287: p_account_tbl csi_datastructures_pub.party_account_tbl;
4288: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4289: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4290: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4291: -- End Add Code for Siebel Genesis Project

Line 4288: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4284: -- Begin Add Code for Siebel Genesis Project
4285: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4286: p_party_tbl csi_datastructures_pub.party_tbl;
4287: p_account_tbl csi_datastructures_pub.party_account_tbl;
4288: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4289: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4290: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4291: -- End Add Code for Siebel Genesis Project
4292:

Line 4289: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4285: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4286: p_party_tbl csi_datastructures_pub.party_tbl;
4287: p_account_tbl csi_datastructures_pub.party_account_tbl;
4288: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4289: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4290: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4291: -- End Add Code for Siebel Genesis Project
4292:
4293: BEGIN

Line 4290: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

4286: p_party_tbl csi_datastructures_pub.party_tbl;
4287: p_account_tbl csi_datastructures_pub.party_account_tbl;
4288: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4289: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4290: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4291: -- End Add Code for Siebel Genesis Project
4292:
4293: BEGIN
4294:

Line 4530: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,

4526: ( p_api_version IN NUMBER,
4527: p_commit IN VARCHAR2,
4528: p_init_msg_list IN VARCHAR2,
4529: p_validation_level IN NUMBER,
4530: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
4531: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4532: x_return_status OUT NOCOPY VARCHAR2,
4533: x_msg_count OUT NOCOPY NUMBER,
4534: x_msg_data OUT NOCOPY VARCHAR2)

Line 4531: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4527: p_commit IN VARCHAR2,
4528: p_init_msg_list IN VARCHAR2,
4529: p_validation_level IN NUMBER,
4530: p_ii_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
4531: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4532: x_return_status OUT NOCOPY VARCHAR2,
4533: x_msg_count OUT NOCOPY NUMBER,
4534: x_msg_data OUT NOCOPY VARCHAR2)
4535: IS

Line 4536: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4532: x_return_status OUT NOCOPY VARCHAR2,
4533: x_msg_count OUT NOCOPY NUMBER,
4534: x_msg_data OUT NOCOPY VARCHAR2)
4535: IS
4536: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4537: l_party_tbl csi_datastructures_pub.party_tbl;
4538: l_account_tbl csi_datastructures_pub.party_account_tbl;
4539: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4540: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4537: l_party_tbl csi_datastructures_pub.party_tbl;

4533: x_msg_count OUT NOCOPY NUMBER,
4534: x_msg_data OUT NOCOPY VARCHAR2)
4535: IS
4536: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4537: l_party_tbl csi_datastructures_pub.party_tbl;
4538: l_account_tbl csi_datastructures_pub.party_account_tbl;
4539: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4540: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4541: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4538: l_account_tbl csi_datastructures_pub.party_account_tbl;

4534: x_msg_data OUT NOCOPY VARCHAR2)
4535: IS
4536: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4537: l_party_tbl csi_datastructures_pub.party_tbl;
4538: l_account_tbl csi_datastructures_pub.party_account_tbl;
4539: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4540: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4541: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4542: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4539: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4535: IS
4536: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4537: l_party_tbl csi_datastructures_pub.party_tbl;
4538: l_account_tbl csi_datastructures_pub.party_account_tbl;
4539: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4540: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4541: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4542: l_instance_id_lst csi_datastructures_pub.id_tbl;
4543: l_instance_rec csi_datastructures_pub.instance_rec;

Line 4540: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4536: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4537: l_party_tbl csi_datastructures_pub.party_tbl;
4538: l_account_tbl csi_datastructures_pub.party_account_tbl;
4539: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4540: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4541: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4542: l_instance_id_lst csi_datastructures_pub.id_tbl;
4543: l_instance_rec csi_datastructures_pub.instance_rec;
4544: l_subject_id NUMBER;

Line 4541: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

4537: l_party_tbl csi_datastructures_pub.party_tbl;
4538: l_account_tbl csi_datastructures_pub.party_account_tbl;
4539: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4540: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4541: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4542: l_instance_id_lst csi_datastructures_pub.id_tbl;
4543: l_instance_rec csi_datastructures_pub.instance_rec;
4544: l_subject_id NUMBER;
4545: l_record_found VARCHAR2(1):= fnd_api.g_true;

Line 4542: l_instance_id_lst csi_datastructures_pub.id_tbl;

4538: l_account_tbl csi_datastructures_pub.party_account_tbl;
4539: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4540: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4541: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4542: l_instance_id_lst csi_datastructures_pub.id_tbl;
4543: l_instance_rec csi_datastructures_pub.instance_rec;
4544: l_subject_id NUMBER;
4545: l_record_found VARCHAR2(1):= fnd_api.g_true;
4546: BEGIN

Line 4543: l_instance_rec csi_datastructures_pub.instance_rec;

4539: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4540: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4541: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4542: l_instance_id_lst csi_datastructures_pub.id_tbl;
4543: l_instance_rec csi_datastructures_pub.instance_rec;
4544: l_subject_id NUMBER;
4545: l_record_found VARCHAR2(1):= fnd_api.g_true;
4546: BEGIN
4547: IF p_ii_relationship_rec.relationship_type_code='COMPONENT-OF' THEN

Line 4649: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

4645: p_api_version IN NUMBER,
4646: p_commit IN VARCHAR2,
4647: p_init_msg_list IN VARCHAR2,
4648: p_validation_level IN NUMBER,
4649: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4650: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4651: x_return_status OUT NOCOPY VARCHAR2,
4652: x_msg_count OUT NOCOPY NUMBER,
4653: x_msg_data OUT NOCOPY VARCHAR2

Line 4650: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4646: p_commit IN VARCHAR2,
4647: p_init_msg_list IN VARCHAR2,
4648: p_validation_level IN NUMBER,
4649: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4650: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4651: x_return_status OUT NOCOPY VARCHAR2,
4652: x_msg_count OUT NOCOPY NUMBER,
4653: x_msg_data OUT NOCOPY VARCHAR2
4654: )

Line 4662: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;

4658: l_api_name CONSTANT VARCHAR2(30) := 'create_relationship';
4659: l_api_version CONSTANT NUMBER := 1.0;
4660: l_return_status_full VARCHAR2(1);
4661: l_access_flag VARCHAR2(1);
4662: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4663: l_line_count NUMBER;
4664: l_relationship_id NUMBER;
4665: l_debug_level NUMBER;
4666: l_relship_history_id NUMBER;

Line 4673: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4669: l_msg_count NUMBER; -- Added by sguthiva for bug 2373109
4670: l_exists VARCHAR2(1);
4671:
4672: -- Added for cascade ownership change bug 2972082
4673: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4674: l_party_tbl csi_datastructures_pub.party_tbl;
4675: l_account_tbl csi_datastructures_pub.party_account_tbl;
4676: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4677: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

Line 4674: l_party_tbl csi_datastructures_pub.party_tbl;

4670: l_exists VARCHAR2(1);
4671:
4672: -- Added for cascade ownership change bug 2972082
4673: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4674: l_party_tbl csi_datastructures_pub.party_tbl;
4675: l_account_tbl csi_datastructures_pub.party_account_tbl;
4676: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4677: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4678: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4675: l_account_tbl csi_datastructures_pub.party_account_tbl;

4671:
4672: -- Added for cascade ownership change bug 2972082
4673: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4674: l_party_tbl csi_datastructures_pub.party_tbl;
4675: l_account_tbl csi_datastructures_pub.party_account_tbl;
4676: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4677: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4678: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4679: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 4676: l_temp_party_tbl csi_datastructures_pub.party_tbl;

4672: -- Added for cascade ownership change bug 2972082
4673: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4674: l_party_tbl csi_datastructures_pub.party_tbl;
4675: l_account_tbl csi_datastructures_pub.party_account_tbl;
4676: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4677: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4678: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4679: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4680: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4677: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

4673: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4674: l_party_tbl csi_datastructures_pub.party_tbl;
4675: l_account_tbl csi_datastructures_pub.party_account_tbl;
4676: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4677: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4678: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4679: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4680: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4681: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4678: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

4674: l_party_tbl csi_datastructures_pub.party_tbl;
4675: l_account_tbl csi_datastructures_pub.party_account_tbl;
4676: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4677: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4678: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4679: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4680: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4681: l_instance_id_lst csi_datastructures_pub.id_tbl;
4682: l_instance_rec csi_datastructures_pub.instance_rec;

Line 4679: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

4675: l_account_tbl csi_datastructures_pub.party_account_tbl;
4676: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4677: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4678: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4679: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4680: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4681: l_instance_id_lst csi_datastructures_pub.id_tbl;
4682: l_instance_rec csi_datastructures_pub.instance_rec;
4683: l_cascade_instance_rec csi_datastructures_pub.instance_rec;

Line 4680: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

4676: l_temp_party_tbl csi_datastructures_pub.party_tbl;
4677: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4678: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4679: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4680: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4681: l_instance_id_lst csi_datastructures_pub.id_tbl;
4682: l_instance_rec csi_datastructures_pub.instance_rec;
4683: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
4684: -- End addition for cascade ownership changes bug 2972082

Line 4681: l_instance_id_lst csi_datastructures_pub.id_tbl;

4677: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
4678: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4679: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4680: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4681: l_instance_id_lst csi_datastructures_pub.id_tbl;
4682: l_instance_rec csi_datastructures_pub.instance_rec;
4683: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
4684: -- End addition for cascade ownership changes bug 2972082
4685:

Line 4682: l_instance_rec csi_datastructures_pub.instance_rec;

4678: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
4679: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4680: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4681: l_instance_id_lst csi_datastructures_pub.id_tbl;
4682: l_instance_rec csi_datastructures_pub.instance_rec;
4683: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
4684: -- End addition for cascade ownership changes bug 2972082
4685:
4686: BEGIN

Line 4683: l_cascade_instance_rec csi_datastructures_pub.instance_rec;

4679: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
4680: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
4681: l_instance_id_lst csi_datastructures_pub.id_tbl;
4682: l_instance_rec csi_datastructures_pub.instance_rec;
4683: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
4684: -- End addition for cascade ownership changes bug 2972082
4685:
4686: BEGIN
4687: -- standard start of api savepoint

Line 5170: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,

5166: p_api_version IN NUMBER,
5167: p_commit IN VARCHAR2,
5168: p_init_msg_list IN VARCHAR2,
5169: p_validation_level IN NUMBER,
5170: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
5171: p_replace_flag IN VARCHAR2,
5172: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5173: x_return_status OUT NOCOPY VARCHAR2,
5174: x_msg_count OUT NOCOPY NUMBER,

Line 5172: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

5168: p_init_msg_list IN VARCHAR2,
5169: p_validation_level IN NUMBER,
5170: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
5171: p_replace_flag IN VARCHAR2,
5172: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5173: x_return_status OUT NOCOPY VARCHAR2,
5174: x_msg_count OUT NOCOPY NUMBER,
5175: x_msg_data OUT NOCOPY VARCHAR2
5176: ) IS

Line 5219: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;

5215: l_count NUMBER;
5216: l_debug_level NUMBER;
5217: l_line_count NUMBER;
5218: l_relship_csr relship_csr%ROWTYPE;
5219: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
5220: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
5221: l_instance_rec csi_datastructures_pub.instance_rec;
5222: l_temp_ins_rec csi_datastructures_pub.instance_rec;
5223: l_object_id NUMBER;

Line 5220: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;

5216: l_debug_level NUMBER;
5217: l_line_count NUMBER;
5218: l_relship_csr relship_csr%ROWTYPE;
5219: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
5220: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
5221: l_instance_rec csi_datastructures_pub.instance_rec;
5222: l_temp_ins_rec csi_datastructures_pub.instance_rec;
5223: l_object_id NUMBER;
5224: l_obv_number NUMBER;

Line 5221: l_instance_rec csi_datastructures_pub.instance_rec;

5217: l_line_count NUMBER;
5218: l_relship_csr relship_csr%ROWTYPE;
5219: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
5220: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
5221: l_instance_rec csi_datastructures_pub.instance_rec;
5222: l_temp_ins_rec csi_datastructures_pub.instance_rec;
5223: l_object_id NUMBER;
5224: l_obv_number NUMBER;
5225: l_ins_usage_code VARCHAR2(30);

Line 5222: l_temp_ins_rec csi_datastructures_pub.instance_rec;

5218: l_relship_csr relship_csr%ROWTYPE;
5219: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
5220: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
5221: l_instance_rec csi_datastructures_pub.instance_rec;
5222: l_temp_ins_rec csi_datastructures_pub.instance_rec;
5223: l_object_id NUMBER;
5224: l_obv_number NUMBER;
5225: l_ins_usage_code VARCHAR2(30);
5226: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 5226: l_instance_id_lst csi_datastructures_pub.id_tbl;

5222: l_temp_ins_rec csi_datastructures_pub.instance_rec;
5223: l_object_id NUMBER;
5224: l_obv_number NUMBER;
5225: l_ins_usage_code VARCHAR2(30);
5226: l_instance_id_lst csi_datastructures_pub.id_tbl;
5227: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5228: l_location_tbl csi_item_instance_pvt.location_tbl;
5229: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5230: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

Line 5232: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

5228: l_location_tbl csi_item_instance_pvt.location_tbl;
5229: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5230: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5231: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5232: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
5233: l_obj_id NUMBER;
5234: l_sub_id NUMBER;
5235: l_msg_data VARCHAR2(2000);
5236: l_msg_index NUMBER;

Line 5241: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;

5237: l_msg_count NUMBER;
5238: l_found BOOLEAN;
5239: l_exists VARCHAR2(1);
5240: -- Added for cascade ownership change bug 2972082
5241: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
5242: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5243: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5244: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5245: l_party_tbl csi_datastructures_pub.party_tbl;

Line 5242: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

5238: l_found BOOLEAN;
5239: l_exists VARCHAR2(1);
5240: -- Added for cascade ownership change bug 2972082
5241: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
5242: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5243: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5244: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5245: l_party_tbl csi_datastructures_pub.party_tbl;
5246: l_account_tbl csi_datastructures_pub.party_account_tbl;

Line 5244: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5240: -- Added for cascade ownership change bug 2972082
5241: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
5242: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5243: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5244: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5245: l_party_tbl csi_datastructures_pub.party_tbl;
5246: l_account_tbl csi_datastructures_pub.party_account_tbl;
5247: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5248: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

Line 5245: l_party_tbl csi_datastructures_pub.party_tbl;

5241: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
5242: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5243: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5244: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5245: l_party_tbl csi_datastructures_pub.party_tbl;
5246: l_account_tbl csi_datastructures_pub.party_account_tbl;
5247: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5248: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5249: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 5246: l_account_tbl csi_datastructures_pub.party_account_tbl;

5242: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5243: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5244: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5245: l_party_tbl csi_datastructures_pub.party_tbl;
5246: l_account_tbl csi_datastructures_pub.party_account_tbl;
5247: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5248: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5249: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5250: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 5247: l_temp_party_tbl csi_datastructures_pub.party_tbl;

5243: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5244: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5245: l_party_tbl csi_datastructures_pub.party_tbl;
5246: l_account_tbl csi_datastructures_pub.party_account_tbl;
5247: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5248: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5249: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5250: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5251: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 5248: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

5244: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5245: l_party_tbl csi_datastructures_pub.party_tbl;
5246: l_account_tbl csi_datastructures_pub.party_account_tbl;
5247: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5248: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5249: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5250: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5251: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5252: l_inst_id_lst csi_datastructures_pub.id_tbl;

Line 5249: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

5245: l_party_tbl csi_datastructures_pub.party_tbl;
5246: l_account_tbl csi_datastructures_pub.party_account_tbl;
5247: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5248: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5249: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5250: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5251: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5252: l_inst_id_lst csi_datastructures_pub.id_tbl;
5253: l_inst_rec csi_datastructures_pub.instance_rec;

Line 5250: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

5246: l_account_tbl csi_datastructures_pub.party_account_tbl;
5247: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5248: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5249: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5250: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5251: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5252: l_inst_id_lst csi_datastructures_pub.id_tbl;
5253: l_inst_rec csi_datastructures_pub.instance_rec;
5254: l_cascade_instance_rec csi_datastructures_pub.instance_rec;

Line 5251: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

5247: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5248: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5249: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5250: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5251: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5252: l_inst_id_lst csi_datastructures_pub.id_tbl;
5253: l_inst_rec csi_datastructures_pub.instance_rec;
5254: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
5255: l_item_id NUMBER;

Line 5252: l_inst_id_lst csi_datastructures_pub.id_tbl;

5248: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5249: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5250: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5251: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5252: l_inst_id_lst csi_datastructures_pub.id_tbl;
5253: l_inst_rec csi_datastructures_pub.instance_rec;
5254: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
5255: l_item_id NUMBER;
5256: l_srl_ctl NUMBER;

Line 5253: l_inst_rec csi_datastructures_pub.instance_rec;

5249: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
5250: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5251: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5252: l_inst_id_lst csi_datastructures_pub.id_tbl;
5253: l_inst_rec csi_datastructures_pub.instance_rec;
5254: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
5255: l_item_id NUMBER;
5256: l_srl_ctl NUMBER;
5257: l_vld_org NUMBER;

Line 5254: l_cascade_instance_rec csi_datastructures_pub.instance_rec;

5250: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
5251: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
5252: l_inst_id_lst csi_datastructures_pub.id_tbl;
5253: l_inst_rec csi_datastructures_pub.instance_rec;
5254: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
5255: l_item_id NUMBER;
5256: l_srl_ctl NUMBER;
5257: l_vld_org NUMBER;
5258: l_loc_type_code VARCHAR2(30);

Line 6018: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,

6014: p_api_version IN NUMBER,
6015: p_commit IN VARCHAR2,
6016: p_init_msg_list IN VARCHAR2,
6017: p_validation_level IN NUMBER,
6018: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
6019: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6020: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
6021: x_return_status OUT NOCOPY VARCHAR2,
6022: x_msg_count OUT NOCOPY NUMBER,

Line 6019: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

6015: p_commit IN VARCHAR2,
6016: p_init_msg_list IN VARCHAR2,
6017: p_validation_level IN NUMBER,
6018: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
6019: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6020: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
6021: x_return_status OUT NOCOPY VARCHAR2,
6022: x_msg_count OUT NOCOPY NUMBER,
6023: x_msg_data OUT NOCOPY VARCHAR2

Line 6020: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,

6016: p_init_msg_list IN VARCHAR2,
6017: p_validation_level IN NUMBER,
6018: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
6019: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6020: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
6021: x_return_status OUT NOCOPY VARCHAR2,
6022: x_msg_count OUT NOCOPY NUMBER,
6023: x_msg_data OUT NOCOPY VARCHAR2
6024: ) IS

Line 6061: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;

6057: l_relship_csr relship_csr%ROWTYPE;
6058: l_api_name CONSTANT VARCHAR2(30) := 'expire_relationship';
6059: l_api_version CONSTANT NUMBER := 1.0;
6060: l_debug_level NUMBER;
6061: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
6062: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
6063: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6064: l_sysdate CONSTANT DATE :=SYSDATE;
6065: l_instance_rec csi_datastructures_pub.instance_rec;

Line 6062: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;

6058: l_api_name CONSTANT VARCHAR2(30) := 'expire_relationship';
6059: l_api_version CONSTANT NUMBER := 1.0;
6060: l_debug_level NUMBER;
6061: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
6062: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
6063: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6064: l_sysdate CONSTANT DATE :=SYSDATE;
6065: l_instance_rec csi_datastructures_pub.instance_rec;
6066: l_temp_ins_rec csi_datastructures_pub.instance_rec;

Line 6063: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

6059: l_api_version CONSTANT NUMBER := 1.0;
6060: l_debug_level NUMBER;
6061: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
6062: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
6063: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6064: l_sysdate CONSTANT DATE :=SYSDATE;
6065: l_instance_rec csi_datastructures_pub.instance_rec;
6066: l_temp_ins_rec csi_datastructures_pub.instance_rec;
6067: l_object_id NUMBER;

Line 6065: l_instance_rec csi_datastructures_pub.instance_rec;

6061: l_old_relship_rec csi_datastructures_pub.ii_relationship_rec;
6062: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
6063: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6064: l_sysdate CONSTANT DATE :=SYSDATE;
6065: l_instance_rec csi_datastructures_pub.instance_rec;
6066: l_temp_ins_rec csi_datastructures_pub.instance_rec;
6067: l_object_id NUMBER;
6068: l_obv_number NUMBER;
6069: l_ins_usage_code VARCHAR2(30);

Line 6066: l_temp_ins_rec csi_datastructures_pub.instance_rec;

6062: l_new_relship_rec csi_datastructures_pub.ii_relationship_rec;
6063: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6064: l_sysdate CONSTANT DATE :=SYSDATE;
6065: l_instance_rec csi_datastructures_pub.instance_rec;
6066: l_temp_ins_rec csi_datastructures_pub.instance_rec;
6067: l_object_id NUMBER;
6068: l_obv_number NUMBER;
6069: l_ins_usage_code VARCHAR2(30);
6070: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 6070: l_instance_id_lst csi_datastructures_pub.id_tbl;

6066: l_temp_ins_rec csi_datastructures_pub.instance_rec;
6067: l_object_id NUMBER;
6068: l_obv_number NUMBER;
6069: l_ins_usage_code VARCHAR2(30);
6070: l_instance_id_lst csi_datastructures_pub.id_tbl;
6071: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6072: l_location_tbl csi_item_instance_pvt.location_tbl;
6073: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6074: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

Line 7020: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,

7016: PROCEDURE validate_ii_relationships(
7017: p_init_msg_list IN VARCHAR2,
7018: p_validation_level IN NUMBER,
7019: p_validation_mode IN VARCHAR2,
7020: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
7021: x_return_status OUT NOCOPY VARCHAR2,
7022: x_msg_count OUT NOCOPY NUMBER,
7023: x_msg_data OUT NOCOPY VARCHAR2
7024: )

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

7117: /* id columns */
7118: /*----------------------------------------------------------*/
7119:
7120: PROCEDURE Resolve_id_columns
7121: (p_rel_history_tbl IN OUT NOCOPY csi_datastructures_pub.relationship_history_tbl)
7122: IS
7123:
7124: BEGIN
7125: IF p_rel_history_tbl.count > 0 THEN

Line 7185: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl

7181: ,p_commit IN VARCHAR2 := fnd_api.g_false
7182: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
7183: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
7184: ,p_transaction_id IN NUMBER
7185: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl
7186: ,x_return_status OUT NOCOPY VARCHAR2
7187: ,x_msg_count OUT NOCOPY NUMBER
7188: ,x_msg_data OUT NOCOPY VARCHAR2
7189: )IS

Line 7196: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;

7192: l_api_version CONSTANT NUMBER := 1.0 ;
7193: l_csi_debug_level NUMBER ;
7194: l_flag VARCHAR2(1) :='N' ;
7195: i NUMBER :=1 ;
7196: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
7197: l_time_stamp DATE ;
7198: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
7199:
7200: CURSOR get_relationship_hist(i_transaction_id NUMBER)

Line 7198: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;

7194: l_flag VARCHAR2(1) :='N' ;
7195: i NUMBER :=1 ;
7196: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
7197: l_time_stamp DATE ;
7198: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
7199:
7200: CURSOR get_relationship_hist(i_transaction_id NUMBER)
7201: IS
7202: SELECT

Line 7468: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

7464: /*-------------------------------------------------------------------*/
7465: PROCEDURE Get_Cyclic_Node
7466: ( p_instance_id IN NUMBER,
7467: p_cyclic_node OUT NOCOPY NUMBER,
7468: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
7469: p_stop_at_cyclic IN VARCHAR2,
7470: x_return_status OUT NOCOPY VARCHAR2,
7471: x_msg_count OUT NOCOPY NUMBER,
7472: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 7486: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;

7482: l_msg_index NUMBER;
7483: l_msg_count NUMBER;
7484: l_debug_level NUMBER;
7485: l_adj_node NUMBER;
7486: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
7487: l_api_name CONSTANT VARCHAR2(50) := 'get_cyclic_node';
7488: --
7489: l_rel_color_tbl csi_ii_relationships_pvt.REL_COLOR_TBL;
7490: l_rel_color_ctr NUMBER := 0;