DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PVT dependencies on CSI_MASS_EDIT_PUB

Line 23: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,

19: p_api_version IN NUMBER,
20: p_commit IN VARCHAR2 := fnd_api.g_false,
21: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
22: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
23: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
24: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
25: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

Line 25: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,

21: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
22: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
23: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
24: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
25: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
28: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
29: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 30: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,

26: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
28: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
29: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
30: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2
34:

Line 43: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,

39: p_api_version IN NUMBER,
40: p_commit IN VARCHAR2 := fnd_api.g_false,
41: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
42: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
43: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
44: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
45: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
46: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
47: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

Line 45: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,

41: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
42: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
43: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
44: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
45: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
46: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
47: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
48: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
49: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 50: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,

46: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
47: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
48: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
49: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
50: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2);
54:

Line 61: p_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,

57: p_api_version IN NUMBER,
58: p_commit IN VARCHAR2 := fnd_api.g_false,
59: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
60: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
61: p_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2
65:

Line 74: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,

70: p_api_version IN NUMBER,
71: p_commit IN VARCHAR2 := fnd_api.g_false,
72: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
73: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
74: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
75: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
76: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
77: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
78: x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 87: x_mass_edit_rec OUT NOCOPY csi_mass_edit_pub.mass_edit_rec)

83: -- Validate the batch ID /Name
84: FUNCTION Is_valid_batch (
85: p_batch_name IN VARCHAR2,
86: p_batch_id IN NUMBER,
87: x_mass_edit_rec OUT NOCOPY csi_mass_edit_pub.mass_edit_rec)
88: RETURN BOOLEAN;
89:
90: --validate the uniqueness of the batch name
91: PROCEDURE validate_batch_name(

Line 94: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

90: --validate the uniqueness of the batch name
91: PROCEDURE validate_batch_name(
92: p_batch_name IN VARCHAR2,
93: p_api_name IN VARCHAR2 ,
94: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
95:
96: --validate batchtype
97: PROCEDURE validate_batch_type(
98: p_batch_type IN VARCHAR2,

Line 101: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

97: PROCEDURE validate_batch_type(
98: p_batch_type IN VARCHAR2,
99: p_api_name IN VARCHAR2,
100: x_sub_type_id OUT NOCOPY NUMBER ,
101: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
102:
103: --validate batch status
104: PROCEDURE validate_batch_status
105: (p_batch_id IN NUMBER ,

Line 106: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

102:
103: --validate batch status
104: PROCEDURE validate_batch_status
105: (p_batch_id IN NUMBER ,
106: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
107:
108: --Procedure to validate the mass update batch
109: PROCEDURE validate_batch (px_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,
110: p_mode IN VARCHAR2,

Line 109: PROCEDURE validate_batch (px_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,

105: (p_batch_id IN NUMBER ,
106: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
107:
108: --Procedure to validate the mass update batch
109: PROCEDURE validate_batch (px_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,
110: p_mode IN VARCHAR2,
111: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
112: x_return_status OUT NOCOPY VARCHAR2);
113:

Line 111: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,

107:
108: --Procedure to validate the mass update batch
109: PROCEDURE validate_batch (px_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,
110: p_mode IN VARCHAR2,
111: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
112: x_return_status OUT NOCOPY VARCHAR2);
113:
114: PROCEDURE log_mu_error (
115: p_index IN NUMBER,

Line 119: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

115: p_index IN NUMBER,
116: p_instance_id IN NUMBER,
117: p_txn_line_detail_id IN NUMBER,
118: p_error_code IN VARCHAR2,
119: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
120:
121: PROCEDURE vld_item_instance_active (p_instance_id_tab IN NumTabType,
122: p_txn_line_detail_id_tab IN NumTabType,
123: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

Line 123: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

119: x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
120:
121: PROCEDURE vld_item_instance_active (p_instance_id_tab IN NumTabType,
122: p_txn_line_detail_id_tab IN NumTabType,
123: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
124:
125: PROCEDURE vld_batch_inst_same_owner(p_txn_line_id_tab IN NumTabType,
126: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
127:

Line 126: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

122: p_txn_line_detail_id_tab IN NumTabType,
123: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
124:
125: PROCEDURE vld_batch_inst_same_owner(p_txn_line_id_tab IN NumTabType,
126: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
127:
128: PROCEDURE vld_batch_inst_curr_owner (p_txn_line_id_tab IN NumTabType,
129: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
130:

Line 129: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

125: PROCEDURE vld_batch_inst_same_owner(p_txn_line_id_tab IN NumTabType,
126: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
127:
128: PROCEDURE vld_batch_inst_curr_owner (p_txn_line_id_tab IN NumTabType,
129: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
130:
131: PROCEDURE vld_child_inst_location(p_instance_id_tab IN NumTabType,
132: p_txn_line_detail_id_tab IN NumTabType,
133: p_instance_usage_code_tab IN Char30TabType,

Line 134: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

130:
131: PROCEDURE vld_child_inst_location(p_instance_id_tab IN NumTabType,
132: p_txn_line_detail_id_tab IN NumTabType,
133: p_instance_usage_code_tab IN Char30TabType,
134: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
135:
136: PROCEDURE vld_item_inst_location(p_instance_id_tab IN NumTabType,
137: p_txn_line_id_tab IN NumTabType,
138: p_location_type_code_tab IN Char30TabType,

Line 142: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

138: p_location_type_code_tab IN Char30TabType,
139: p_location_id_tab IN NumTabType,
140: p_install_location_id_tab IN NumTabType,
141: p_instance_status_id_tab IN NumTabType,
142: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
143:
144: PROCEDURE check_item_inst_loc_changed(p_txn_line_detail_id_tab IN NumTabType,
145: p_instance_id_tab IN NumTabType,
146: p_install_location_id_tab IN NumTabType,

Line 152: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

148: p_instance_status_id_tab IN NumTabType,
149: p_external_reference_tab IN Char30TabType,
150: p_install_date_tab IN DateTabType,
151: p_system_id_tab IN NumTabType,
152: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
153:
154: PROCEDURE vld_xfer_date(p_txn_line_id_tab IN NumTabType,
155: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
156:

Line 155: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

151: p_system_id_tab IN NumTabType,
152: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
153:
154: PROCEDURE vld_xfer_date(p_txn_line_id_tab IN NumTabType,
155: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
156:
157: PROCEDURE vld_term_date(p_txn_line_id_tab IN NumTabType,
158: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
159:

Line 158: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);

154: PROCEDURE vld_xfer_date(p_txn_line_id_tab IN NumTabType,
155: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
156:
157: PROCEDURE vld_term_date(p_txn_line_id_tab IN NumTabType,
158: px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
159:
160: /*----------------------------------------------------*/
161: /* Procedure name: VLD_SYSTEM_ACTIVE */
162: /* Description : procedure to validate whether the */

Line 168: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl);

164: /*----------------------------------------------------*/
165: PROCEDURE VLD_SYSTEM_ACTIVE(
166: p_system_id IN NUMBER ,
167: p_txn_line_id IN NUMBER,
168: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl);
169:
170:
171: /*----------------------------------------------------*/
172: /* Procedure name: VLD_SYSTEM_CURRENT_OWNER */

Line 180: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl);

176: PROCEDURE VLD_SYSTEM_CURRENT_OWNER(
177: p_system_id IN NUMBER ,
178: p_customer_id IN NUMBER,
179: p_txn_line_id IN NUMBER,
180: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl);
181:
182: /*----------------------------------------------------*/
183: /* Procedure name: VLD_SYSTEM_LOCATION_CHGD */
184: /* Description : procedure to validate whether the location */

Line 190: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl);

186: /*----------------------------------------------------*/
187: PROCEDURE VLD_SYSTEM_LOCATION_CHGD(
188: p_system_id IN NUMBER ,
189: p_txn_line_id IN NUMBER,
190: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl);
191:
192: End CSI_MASS_EDIT_PVT;