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 FND_API

Line 32: p_stop_at_cyclic IN VARCHAR2 DEFAULT FND_API.G_TRUE,

28: PROCEDURE Get_Cyclic_Node
29: ( p_instance_id IN NUMBER,
30: p_cyclic_node OUT NOCOPY NUMBER,
31: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
32: p_stop_at_cyclic IN VARCHAR2 DEFAULT FND_API.G_TRUE,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,
35: x_msg_data OUT NOCOPY VARCHAR2 );
36: --

Line 54: p_commit IN VARCHAR2 := fnd_api.g_false,

50:
51: PROCEDURE get_cyclic_relationships
52: (
53: p_api_version IN NUMBER,
54: p_commit IN VARCHAR2 := fnd_api.g_false,
55: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
56: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
57: p_instance_id IN NUMBER ,
58: p_depth IN NUMBER,

Line 55: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

51: PROCEDURE get_cyclic_relationships
52: (
53: p_api_version IN NUMBER,
54: p_commit IN VARCHAR2 := fnd_api.g_false,
55: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
56: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
57: p_instance_id IN NUMBER ,
58: p_depth IN NUMBER,
59: p_time_stamp IN DATE,

Line 56: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

52: (
53: p_api_version IN NUMBER,
54: p_commit IN VARCHAR2 := fnd_api.g_false,
55: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
56: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
57: p_instance_id IN NUMBER ,
58: p_depth IN NUMBER,
59: p_time_stamp IN DATE,
60: p_active_relationship_only IN VARCHAR2 := fnd_api.g_false,

Line 60: p_active_relationship_only IN VARCHAR2 := fnd_api.g_false,

56: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
57: p_instance_id IN NUMBER ,
58: p_depth IN NUMBER,
59: p_time_stamp IN DATE,
60: p_active_relationship_only IN VARCHAR2 := fnd_api.g_false,
61: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2

Line 72: p_commit IN VARCHAR2 := fnd_api.g_false,

68:
69: PROCEDURE get_relationships
70: (
71: p_api_version IN NUMBER,
72: p_commit IN VARCHAR2 := fnd_api.g_false,
73: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
74: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
75: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
76: p_depth IN NUMBER,

Line 73: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

69: PROCEDURE get_relationships
70: (
71: p_api_version IN NUMBER,
72: p_commit IN VARCHAR2 := fnd_api.g_false,
73: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
74: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
75: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
76: p_depth IN NUMBER,
77: p_time_stamp IN DATE,

Line 74: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

70: (
71: p_api_version IN NUMBER,
72: p_commit IN VARCHAR2 := fnd_api.g_false,
73: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
74: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
75: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
76: p_depth IN NUMBER,
77: p_time_stamp IN DATE,
78: p_active_relationship_only IN VARCHAR2 := fnd_api.g_false,

Line 78: p_active_relationship_only IN VARCHAR2 := fnd_api.g_false,

74: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
75: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
76: p_depth IN NUMBER,
77: p_time_stamp IN DATE,
78: p_active_relationship_only IN VARCHAR2 := fnd_api.g_false,
79: p_recursive_flag IN VARCHAR2 := fnd_api.g_false,
80: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,

Line 79: p_recursive_flag IN VARCHAR2 := fnd_api.g_false,

75: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
76: p_depth IN NUMBER,
77: p_time_stamp IN DATE,
78: p_active_relationship_only IN VARCHAR2 := fnd_api.g_false,
79: p_recursive_flag IN VARCHAR2 := fnd_api.g_false,
80: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2

Line 89: p_commit IN VARCHAR2 := fnd_api.g_false,

85:
86:
87: PROCEDURE create_relationship(
88: p_api_version IN NUMBER,
89: p_commit IN VARCHAR2 := fnd_api.g_false,
90: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
91: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
92: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
93: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 90: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

86:
87: PROCEDURE create_relationship(
88: p_api_version IN NUMBER,
89: p_commit IN VARCHAR2 := fnd_api.g_false,
90: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
91: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
92: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
93: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
94: x_return_status OUT NOCOPY VARCHAR2,

Line 91: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

87: PROCEDURE create_relationship(
88: p_api_version IN NUMBER,
89: p_commit IN VARCHAR2 := fnd_api.g_false,
90: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
91: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
92: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
93: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,

Line 102: p_commit IN VARCHAR2 := fnd_api.g_false,

98:
99: PROCEDURE update_relationship
100: (
101: p_api_version IN NUMBER,
102: p_commit IN VARCHAR2 := fnd_api.g_false,
103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
104: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
105: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
106: p_replace_flag IN VARCHAR2 := fnd_api.g_false,

Line 103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

99: PROCEDURE update_relationship
100: (
101: p_api_version IN NUMBER,
102: p_commit IN VARCHAR2 := fnd_api.g_false,
103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
104: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
105: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
106: p_replace_flag IN VARCHAR2 := fnd_api.g_false,
107: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 104: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

100: (
101: p_api_version IN NUMBER,
102: p_commit IN VARCHAR2 := fnd_api.g_false,
103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
104: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
105: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
106: p_replace_flag IN VARCHAR2 := fnd_api.g_false,
107: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
108: x_return_status OUT NOCOPY VARCHAR2,

Line 106: p_replace_flag IN VARCHAR2 := fnd_api.g_false,

102: p_commit IN VARCHAR2 := fnd_api.g_false,
103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
104: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
105: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
106: p_replace_flag IN VARCHAR2 := fnd_api.g_false,
107: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2

Line 116: p_commit IN VARCHAR2 := fnd_api.g_false,

112:
113: PROCEDURE expire_relationship
114: (
115: p_api_version IN NUMBER,
116: p_commit IN VARCHAR2 := fnd_api.g_false,
117: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
118: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
119: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
120: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 117: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

113: PROCEDURE expire_relationship
114: (
115: p_api_version IN NUMBER,
116: p_commit IN VARCHAR2 := fnd_api.g_false,
117: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
118: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
119: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
120: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
121: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,

Line 118: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

114: (
115: p_api_version IN NUMBER,
116: p_commit IN VARCHAR2 := fnd_api.g_false,
117: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
118: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
119: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
120: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
121: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
122: x_return_status OUT NOCOPY VARCHAR2,

Line 147: ,p_commit IN VARCHAR2 := fnd_api.g_false

143:
144: PROCEDURE get_inst_relationship_hist
145: (
146: p_api_version IN NUMBER
147: ,p_commit IN VARCHAR2 := fnd_api.g_false
148: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
149: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
150: ,p_transaction_id IN NUMBER
151: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl

Line 148: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

144: PROCEDURE get_inst_relationship_hist
145: (
146: p_api_version IN NUMBER
147: ,p_commit IN VARCHAR2 := fnd_api.g_false
148: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
149: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
150: ,p_transaction_id IN NUMBER
151: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl
152: ,x_return_status OUT NOCOPY VARCHAR2

Line 149: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

145: (
146: p_api_version IN NUMBER
147: ,p_commit IN VARCHAR2 := fnd_api.g_false
148: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
149: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
150: ,p_transaction_id IN NUMBER
151: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER

Line 166: p_active_instances_only IN VARCHAR2 DEFAULT fnd_api.g_true,

162: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
163: p_rel_type_code IN VARCHAR2,
164: p_time_stamp IN DATE,
165: p_active_relationship_only IN VARCHAR2,
166: p_active_instances_only IN VARCHAR2 DEFAULT fnd_api.g_true,
167: p_config_only IN VARCHAR2 DEFAULT fnd_api.g_false -- if true will retrieve instances with config keys
168: );
169: --
170: FUNCTION Parent_of

Line 167: p_config_only IN VARCHAR2 DEFAULT fnd_api.g_false -- if true will retrieve instances with config keys

163: p_rel_type_code IN VARCHAR2,
164: p_time_stamp IN DATE,
165: p_active_relationship_only IN VARCHAR2,
166: p_active_instances_only IN VARCHAR2 DEFAULT fnd_api.g_true,
167: p_config_only IN VARCHAR2 DEFAULT fnd_api.g_false -- if true will retrieve instances with config keys
168: );
169: --
170: FUNCTION Parent_of
171: ( p_subject_id IN NUMBER,

Line 208: p_active_instances_only IN VARCHAR2 DEFAULT fnd_api.g_true, -- should be passed as false only when un-expiring

204: (p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
205: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
206: p_depth IN NUMBER,
207: p_active_relationship_only IN VARCHAR2,
208: p_active_instances_only IN VARCHAR2 DEFAULT fnd_api.g_true, -- should be passed as false only when un-expiring
209: p_config_only IN VARCHAR2 DEFAULT fnd_api.g_false, -- if true will retrieve instances with config keys
210: p_time_stamp IN DATE,
211: p_get_dfs IN VARCHAR2 DEFAULT FND_API.G_TRUE,
212: p_ii_relationship_level_tbl OUT NOCOPY csi_ii_relationships_pvt.ii_relationship_level_tbl,

Line 209: p_config_only IN VARCHAR2 DEFAULT fnd_api.g_false, -- if true will retrieve instances with config keys

205: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
206: p_depth IN NUMBER,
207: p_active_relationship_only IN VARCHAR2,
208: p_active_instances_only IN VARCHAR2 DEFAULT fnd_api.g_true, -- should be passed as false only when un-expiring
209: p_config_only IN VARCHAR2 DEFAULT fnd_api.g_false, -- if true will retrieve instances with config keys
210: p_time_stamp IN DATE,
211: p_get_dfs IN VARCHAR2 DEFAULT FND_API.G_TRUE,
212: p_ii_relationship_level_tbl OUT NOCOPY csi_ii_relationships_pvt.ii_relationship_level_tbl,
213: x_return_status OUT NOCOPY VARCHAR2,

Line 211: p_get_dfs IN VARCHAR2 DEFAULT FND_API.G_TRUE,

207: p_active_relationship_only IN VARCHAR2,
208: p_active_instances_only IN VARCHAR2 DEFAULT fnd_api.g_true, -- should be passed as false only when un-expiring
209: p_config_only IN VARCHAR2 DEFAULT fnd_api.g_false, -- if true will retrieve instances with config keys
210: p_time_stamp IN DATE,
211: p_get_dfs IN VARCHAR2 DEFAULT FND_API.G_TRUE,
212: p_ii_relationship_level_tbl OUT NOCOPY csi_ii_relationships_pvt.ii_relationship_level_tbl,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2

Line 241: relationship_id NUMBER := FND_API.G_MISS_NUM,

237: );
238:
239: TYPE ii_relationship_level_rec IS RECORD
240: (
241: relationship_id NUMBER := FND_API.G_MISS_NUM,
242: current_level NUMBER := FND_API.G_MISS_NUM
243: );
244:
245: TYPE ii_relationship_level_tbl IS TABLE OF ii_relationship_level_rec

Line 242: current_level NUMBER := FND_API.G_MISS_NUM

238:
239: TYPE ii_relationship_level_rec IS RECORD
240: (
241: relationship_id NUMBER := FND_API.G_MISS_NUM,
242: current_level NUMBER := FND_API.G_MISS_NUM
243: );
244:
245: TYPE ii_relationship_level_tbl IS TABLE OF ii_relationship_level_rec
246: INDEX BY BINARY_INTEGER;