APPS.PN_VAREN_PVT dependencies on PN_VAR_BKDT_DEFAULTS_PKG

Line 879: -- PURPOSE : Calling pn_var_bkdt_defaults_pkg.insert_row package

875:
876: --------------------------------------------------------------------------------
877: -- NAME : INSERT_BREAKPOINT_DETAILS
878: -- DESCRIPTION : Insert records into Breakpoint Details
879: -- PURPOSE : Calling pn_var_bkdt_defaults_pkg.insert_row package
880: -- INVOKED FROM :
881: -- ARGUMENTS : P_BREAKPOINT_DETAILS_REC_TYPE IN Parameter
882: -- : X_RETURN_STATUS OUT Parameter
883: -- REFERENCE :

Line 898: ('PN_VAREN_PVT: Insert_Breakpoint_Details: Start of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW package'

894: l_null VARCHAR2 (10) := NULL;
895: BEGIN
896: p_breakpoint_details_rec_type.bkdt_default_id := NULL;
897: pn_varen_util.pvt_debug
898: ('PN_VAREN_PVT: Insert_Breakpoint_Details: Start of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW package'
899: , 3
900: );
901: pn_varen_util.pvt_debug
902: ( 'PN_VAREN_PVT: Insert_Breakpoint_Details: p_breakpoint_details_rec_type.BKDT_DEFAULT_ID : '

Line 957: ('PN_VAREN_PVT: Insert_Breakpoint_Details: End of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW package'

953: || p_breakpoint_details_rec_type.annual_basis_amount
954: , 3
955: );
956: pn_varen_util.pvt_debug
957: ('PN_VAREN_PVT: Insert_Breakpoint_Details: End of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW package'
958: , 3
959: );
960: pn_varen_util.pvt_debug ( ' Value of bkdt_detail_num , before pn_var_bkdt_defaults_pkg.insert_row : '
961: || p_breakpoint_details_rec_type.bkdt_detail_num

Line 960: pn_varen_util.pvt_debug ( ' Value of bkdt_detail_num , before pn_var_bkdt_defaults_pkg.insert_row : '

956: pn_varen_util.pvt_debug
957: ('PN_VAREN_PVT: Insert_Breakpoint_Details: End of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW package'
958: , 3
959: );
960: pn_varen_util.pvt_debug ( ' Value of bkdt_detail_num , before pn_var_bkdt_defaults_pkg.insert_row : '
961: || p_breakpoint_details_rec_type.bkdt_detail_num
962: , 3
963: );
964: pn_varen_util.pvt_debug ( ' Value of bkpt_rate , before pn_var_bkdt_defaults_pkg.insert_row : '

Line 964: pn_varen_util.pvt_debug ( ' Value of bkpt_rate , before pn_var_bkdt_defaults_pkg.insert_row : '

960: pn_varen_util.pvt_debug ( ' Value of bkdt_detail_num , before pn_var_bkdt_defaults_pkg.insert_row : '
961: || p_breakpoint_details_rec_type.bkdt_detail_num
962: , 3
963: );
964: pn_varen_util.pvt_debug ( ' Value of bkpt_rate , before pn_var_bkdt_defaults_pkg.insert_row : '
965: || p_breakpoint_details_rec_type.bkpt_rate
966: , 3
967: );
968: pn_var_bkdt_defaults_pkg.insert_row

Line 968: pn_var_bkdt_defaults_pkg.insert_row

964: pn_varen_util.pvt_debug ( ' Value of bkpt_rate , before pn_var_bkdt_defaults_pkg.insert_row : '
965: || p_breakpoint_details_rec_type.bkpt_rate
966: , 3
967: );
968: pn_var_bkdt_defaults_pkg.insert_row
969: (x_rowid => l_rowid
970: , x_bkdt_default_id => p_breakpoint_details_rec_type.bkdt_default_id
971: , x_bkdt_detail_num => p_breakpoint_details_rec_type.bkdt_detail_num
972: , x_bkhd_default_id => p_breakpoint_details_rec_type.bkhd_default_id

Line 1022: ('PN_VAREN_PVT: Insert_Breakpoint_Details: Success Result of pn_var_bkdt_defaults_pkg.insert_row package'

1018: , x_attribute15 => p_breakpoint_details_rec_type.attribute15
1019: );
1020: x_return_status := fnd_api.g_ret_sts_success;
1021: pn_varen_util.pvt_debug
1022: ('PN_VAREN_PVT: Insert_Breakpoint_Details: Success Result of pn_var_bkdt_defaults_pkg.insert_row package'
1023: , 3
1024: );
1025: EXCEPTION
1026: WHEN OTHERS

Line 1039: -- PURPOSE : Calling pn_var_bkdt_defaults_pkg.update_row package

1035:
1036: --------------------------------------------------------------------------------
1037: -- NAME : UPDATE_BREAKPOINT_DETAILS
1038: -- DESCRIPTION : Update records into Breakpoint Details
1039: -- PURPOSE : Calling pn_var_bkdt_defaults_pkg.update_row package
1040: -- INVOKED FROM :
1041: -- ARGUMENTS : P_BREAKPOINT_DETAILS_REC_TYPE IN Parameter
1042: -- : X_RETURN_STATUS OUT Parameter
1043: -- REFERENCE :

Line 1056: ('PN_VAREN_PVT: Update_Breakpoint_Details: Start of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW package'

1052: IS
1053: l_not_used VARCHAR2 (20) := NULL;
1054: BEGIN
1055: pn_varen_util.pvt_debug
1056: ('PN_VAREN_PVT: Update_Breakpoint_Details: Start of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW package'
1057: , 3
1058: );
1059: pn_varen_util.pvt_debug
1060: ( 'PN_VAREN_PVT: Update_Breakpoint_Details: p_breakpoint_details_rec_type.BKDT_DEFAULT_ID : '

Line 1115: ('PN_VAREN_PVT: Update_Breakpoint_Details: End of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW package'

1111: || p_breakpoint_details_rec_type.annual_basis_amount
1112: , 3
1113: );
1114: pn_varen_util.pvt_debug
1115: ('PN_VAREN_PVT: Update_Breakpoint_Details: End of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW package'
1116: , 3
1117: );
1118: pn_var_bkdt_defaults_pkg.update_row
1119: (x_bkdt_default_id => p_breakpoint_details_rec_type.bkdt_default_id

Line 1118: pn_var_bkdt_defaults_pkg.update_row

1114: pn_varen_util.pvt_debug
1115: ('PN_VAREN_PVT: Update_Breakpoint_Details: End of Input parameters for PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW package'
1116: , 3
1117: );
1118: pn_var_bkdt_defaults_pkg.update_row
1119: (x_bkdt_default_id => p_breakpoint_details_rec_type.bkdt_default_id
1120: , x_bkdt_detail_num => p_breakpoint_details_rec_type.bkdt_detail_num
1121: , x_bkhd_default_id => p_breakpoint_details_rec_type.bkhd_default_id
1122: , x_bkdt_start_date => p_breakpoint_details_rec_type.bkdt_start_date

Line 1158: ('PN_VAREN_PVT: Update_Breakpoint_Details: Success Result of pn_var_bkdt_defaults_pkg.update_row package'

1154: , x_attribute15 => p_breakpoint_details_rec_type.attribute15
1155: );
1156: x_return_status := fnd_api.g_ret_sts_success;
1157: pn_varen_util.pvt_debug
1158: ('PN_VAREN_PVT: Update_Breakpoint_Details: Success Result of pn_var_bkdt_defaults_pkg.update_row package'
1159: , 3
1160: );
1161: EXCEPTION
1162: WHEN OTHERS