DBA Data[Home] [Help]

APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on CSI_T_DATASTRUCTURES_GRP

Line 27: x_transaction_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

23: p_api_name IN VARCHAR2);
24:
25: PROCEDURE validate_transaction_line_id(
26: p_transaction_line_id IN NUMBER,
27: x_transaction_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
28: x_return_status OUT NOCOPY VARCHAR2);
29:
30: PROCEDURE validate_txn_line_detail_id(
31: p_txn_line_detail_id IN NUMBER,

Line 37: x_txn_line_detail_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

33:
34: -- Added for M-M
35: PROCEDURE validate_txn_line_detail_id(
36: p_txn_line_detail_id IN NUMBER,
37: x_txn_line_detail_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
38: x_return_status OUT NOCOPY VARCHAR2);
39:
40: PROCEDURE validate_txn_party_detail_id(
41: p_txn_party_detail_id IN NUMBER,

Line 89: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

85: x_return_status OUT NOCOPY VARCHAR2);
86:
87: PROCEDURE check_source_integrity(
88: p_validation_level IN VARCHAR2,
89: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
90: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
91: x_return_status OUT NOCOPY VARCHAR2);
92:
93: /* used in the main create */

Line 90: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

86:
87: PROCEDURE check_source_integrity(
88: p_validation_level IN VARCHAR2,
89: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
90: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
91: x_return_status OUT NOCOPY VARCHAR2);
92:
93: /* used in the main create */
94: PROCEDURE check_party_integrity(

Line 95: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

91: x_return_status OUT NOCOPY VARCHAR2);
92:
93: /* used in the main create */
94: PROCEDURE check_party_integrity(
95: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
96: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
97: p_party_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
98: x_return_status OUT NOCOPY VARCHAR2);
99:

Line 96: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

92:
93: /* used in the main create */
94: PROCEDURE check_party_integrity(
95: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
96: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
97: p_party_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
98: x_return_status OUT NOCOPY VARCHAR2);
99:
100: PROCEDURE convert_rltns_index_to_ids(

Line 97: p_party_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,

93: /* used in the main create */
94: PROCEDURE check_party_integrity(
95: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
96: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
97: p_party_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
98: x_return_status OUT NOCOPY VARCHAR2);
99:
100: PROCEDURE convert_rltns_index_to_ids(
101: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

Line 101: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

97: p_party_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
98: x_return_status OUT NOCOPY VARCHAR2);
99:
100: PROCEDURE convert_rltns_index_to_ids(
101: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
102: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
103: x_return_status OUT NOCOPY varchar2);
104:
105: /* used in the standalone party create */

Line 102: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

98: x_return_status OUT NOCOPY VARCHAR2);
99:
100: PROCEDURE convert_rltns_index_to_ids(
101: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
102: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
103: x_return_status OUT NOCOPY varchar2);
104:
105: /* used in the standalone party create */
106: PROCEDURE is_valid_owner_for_create(

Line 114: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

110:
111: -- Added for M-M
112: procedure get_txn_line_dtl_rec(
113: p_index_id IN NUMBER,
114: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
115: x_txn_line_detail_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
116: x_return_status OUT NOCOPY VARCHAR2);
117:
118: PROCEDURE check_rltns_integrity(

Line 115: x_txn_line_detail_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

111: -- Added for M-M
112: procedure get_txn_line_dtl_rec(
113: p_index_id IN NUMBER,
114: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
115: x_txn_line_detail_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
116: x_return_status OUT NOCOPY VARCHAR2);
117:
118: PROCEDURE check_rltns_integrity(
119: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

Line 119: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

115: x_txn_line_detail_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
116: x_return_status OUT NOCOPY VARCHAR2);
117:
118: PROCEDURE check_rltns_integrity(
119: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
120: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
121: x_return_status OUT NOCOPY VARCHAR2);
122:
123: PROCEDURE get_processing_status(

Line 120: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

116: x_return_status OUT NOCOPY VARCHAR2);
117:
118: PROCEDURE check_rltns_integrity(
119: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
120: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
121: x_return_status OUT NOCOPY VARCHAR2);
122:
123: PROCEDURE get_processing_status(
124: p_level IN varchar2,

Line 173: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl,

169: x_return_status OUT NOCOPY varchar2);
170:
171: PROCEDURE get_txn_system_id(
172: p_txn_systems_index IN number,
173: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl,
174: x_txn_system_id OUT NOCOPY number,
175: x_return_status OUT NOCOPY varchar2);
176:
177: PROCEDURE get_txn_systems_index(

Line 179: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl,

175: x_return_status OUT NOCOPY varchar2);
176:
177: PROCEDURE get_txn_systems_index(
178: p_txn_system_id IN number,
179: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl,
180: x_txn_systems_index OUT NOCOPY number,
181: x_return_status OUT NOCOPY varchar2);
182:
183: PROCEDURE validate_contact_flag(

Line 198: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

194: p_sub_type_id IN number,
195: x_return_status OUT NOCOPY varchar2);
196:
197: PROCEDURE check_duplicate(
198: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
199: x_return_status OUT NOCOPY varchar2);
200:
201: PROCEDURE validate_lot_number(
202: p_inventory_item_id IN number,

Line 215: p_txn_line_detail_rec1 IN csi_t_datastructures_grp.txn_line_detail_rec,

211: x_return_status OUT NOCOPY varchar2);
212:
213: -- Added for M-M
214: PROCEDURE validate_txn_rltnshp (
215: p_txn_line_detail_rec1 IN csi_t_datastructures_grp.txn_line_detail_rec,
216: p_txn_line_detail_rec2 IN csi_t_datastructures_grp.txn_line_detail_rec,
217: p_iir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
218: x_return_status OUT NOCOPY varchar2);
219:

Line 216: p_txn_line_detail_rec2 IN csi_t_datastructures_grp.txn_line_detail_rec,

212:
213: -- Added for M-M
214: PROCEDURE validate_txn_rltnshp (
215: p_txn_line_detail_rec1 IN csi_t_datastructures_grp.txn_line_detail_rec,
216: p_txn_line_detail_rec2 IN csi_t_datastructures_grp.txn_line_detail_rec,
217: p_iir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
218: x_return_status OUT NOCOPY varchar2);
219:
220: -- Added for M-M

Line 217: p_iir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,

213: -- Added for M-M
214: PROCEDURE validate_txn_rltnshp (
215: p_txn_line_detail_rec1 IN csi_t_datastructures_grp.txn_line_detail_rec,
216: p_txn_line_detail_rec2 IN csi_t_datastructures_grp.txn_line_detail_rec,
217: p_iir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
218: x_return_status OUT NOCOPY varchar2);
219:
220: -- Added for M-M
221: PROCEDURE validate_inst_details (

Line 222: p_iir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,

218: x_return_status OUT NOCOPY varchar2);
219:
220: -- Added for M-M
221: PROCEDURE validate_inst_details (
222: p_iir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
223: p_txn_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
224: x_return_status OUT NOCOPY varchar2);
225:
226: -- Added for M-M

Line 223: p_txn_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

219:
220: -- Added for M-M
221: PROCEDURE validate_inst_details (
222: p_iir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
223: p_txn_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
224: x_return_status OUT NOCOPY varchar2);
225:
226: -- Added for M-M
227: PROCEDURE validate_src_header (

Line 235: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

231: x_return_status OUT NOCOPY varchar2);
232:
233: --Added for CZ
234: PROCEDURE check_exists_in_cz(
235: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
236: x_return_status OUT NOCOPY VARCHAR2);
237:
238: --Added for CZ
239: PROCEDURE get_cz_inst_or_tld_id (