DBA Data[Home] [Help]

APPS.PN_VAREN_PVT dependencies on PN_VAR_CONSTR_DEFAULTS_PKG

Line 9: -- PURPOSE : Calling pn_var_constr_defaults_pkg.insert_row procedure

5:
6: --------------------------------------------------------------------------------
7: -- NAME : INSERT_CONSTRAINTS
8: -- DESCRIPTION :
9: -- PURPOSE : Calling pn_var_constr_defaults_pkg.insert_row procedure
10: -- INVOKED FROM :
11: -- ARGUMENTS : p_constraints_rec_type, x_return_status
12: -- REFERENCE :
13: -- HISTORY :

Line 30: ('PN_VAREN_PVT: Insert_Constraints: Input parameters to PN_VAR_CONSTR_DEFAULTS_PKG.Insert_Row package'

26: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Start of Insert_Constraints Procedure'
27: , 3
28: );
29: pn_varen_util.pvt_debug
30: ('PN_VAREN_PVT: Insert_Constraints: Input parameters to PN_VAR_CONSTR_DEFAULTS_PKG.Insert_Row package'
31: , 3
32: );
33: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.constr_default_id : '
34: || p_constraints_rec_type.constr_default_id

Line 81: pn_var_constr_defaults_pkg.insert_row (x_rowid => g_rowid

77: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Insert_Constraints: p_constraints_rec_type.attribute_category : '
78: || p_constraints_rec_type.attribute_category
79: , 3
80: );
81: pn_var_constr_defaults_pkg.insert_row (x_rowid => g_rowid
82: , x_constr_default_id => p_constraints_rec_type.constr_default_id
83: , x_constr_default_num => p_constraints_rec_type.constr_default_num
84: , x_var_rent_id => p_constraints_rec_type.var_rent_id
85: , x_agreement_template_id => p_constraints_rec_type.agreement_template_id

Line 133: ('PN_VAREN_PVT: Insert_Constraints: End of parameters to PN_VAR_CONSTR_DEFAULTS_PKG.Insert_Row package'

129: , x_attribute15 => p_constraints_rec_type.attribute15
130: );
131: x_return_status := fnd_api.g_ret_sts_success;
132: pn_varen_util.pvt_debug
133: ('PN_VAREN_PVT: Insert_Constraints: End of parameters to PN_VAR_CONSTR_DEFAULTS_PKG.Insert_Row package'
134: , 3
135: );
136: EXCEPTION
137: WHEN OTHERS

Line 140: ( 'PN_VAREN_PVT: Insert_Constraints: Exception Result of Pn_Var_Constr_Defaults_Pkg.Insert_Row procedure : '

136: EXCEPTION
137: WHEN OTHERS
138: THEN
139: pn_varen_util.pvt_debug
140: ( 'PN_VAREN_PVT: Insert_Constraints: Exception Result of Pn_Var_Constr_Defaults_Pkg.Insert_Row procedure : '
141: || SQLERRM
142: , 3
143: );
144: x_return_status := fnd_api.g_ret_sts_error;

Line 150: -- PURPOSE : Calling pn_var_constr_defaults_pkg.update_row procedure

146:
147: --------------------------------------------------------------------------------
148: -- NAME : UPDATE_CONSTRAINTS
149: -- DESCRIPTION :
150: -- PURPOSE : Calling pn_var_constr_defaults_pkg.update_row procedure
151: -- INVOKED FROM :
152: -- ARGUMENTS : p_constraints_rec_type, x_return_status
153: -- REFERENCE :
154: -- HISTORY :

Line 169: ('PN_VAREN_PVT: Update_Constraints: Start of Input parameters to pn_var_constr_defaults_pkg.update_row package'

165: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Start of Update_Constraints Procedure'
166: , 3
167: );
168: pn_varen_util.pvt_debug
169: ('PN_VAREN_PVT: Update_Constraints: Start of Input parameters to pn_var_constr_defaults_pkg.update_row package'
170: , 3
171: );
172: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Constraints: p_constraints_rec_type.constr_default_id : '
173: || p_constraints_rec_type.constr_default_id

Line 221: ('PN_VAREN_PVT: Update_Constraints: End of Input parameters to pn_var_constr_defaults_pkg.update_row package'

217: || p_constraints_rec_type.attribute_category
218: , 3
219: );
220: pn_varen_util.pvt_debug
221: ('PN_VAREN_PVT: Update_Constraints: End of Input parameters to pn_var_constr_defaults_pkg.update_row package'
222: , 3
223: );
224: pn_var_constr_defaults_pkg.update_row
225: (x_constr_default_id => p_constraints_rec_type.constr_default_id

Line 224: pn_var_constr_defaults_pkg.update_row

220: pn_varen_util.pvt_debug
221: ('PN_VAREN_PVT: Update_Constraints: End of Input parameters to pn_var_constr_defaults_pkg.update_row package'
222: , 3
223: );
224: pn_var_constr_defaults_pkg.update_row
225: (x_constr_default_id => p_constraints_rec_type.constr_default_id
226: , x_constr_default_num => p_constraints_rec_type.constr_default_num
227: , x_var_rent_id => p_constraints_rec_type.var_rent_id
228: , x_agreement_template_id => p_constraints_rec_type.agreement_template_id

Line 260: ('PN_VAREN_PVT: Update_Constraints: End of parameters to pn_var_constr_defaults_pkg.update_Row package'

256: , x_attribute15 => p_constraints_rec_type.attribute15
257: );
258: x_return_status := fnd_api.g_ret_sts_success;
259: pn_varen_util.pvt_debug
260: ('PN_VAREN_PVT: Update_Constraints: End of parameters to pn_var_constr_defaults_pkg.update_Row package'
261: , 3
262: );
263: EXCEPTION
264: WHEN OTHERS