DBA Data[Home] [Help]

APPS.PN_VAREN_PVT dependencies on PN_VAR_LINE_DEFAULTS_PKG

Line 1459: -- PURPOSE : Calling pn_var_line_defaults_pkg.insert_row package

1455:
1456: --------------------------------------------------------------------------------
1457: -- NAME : INSERT_VARIABLE_RENT_LINES
1458: -- DESCRIPTION : Insert records into Variable Rent Lines
1459: -- PURPOSE : Calling pn_var_line_defaults_pkg.insert_row package
1460: -- INVOKED FROM :
1461: -- ARGUMENTS : P_VARIABLE_RENT_LINES_REC_TYPE IN Parameter
1462: -- : X_RETURN_STATUS OUT Parameter
1463: -- REFERENCE :

Line 1486: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: Calling PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW Package'

1482: l_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
1483: BEGIN
1484: -- NULL;
1485: pn_varen_util.pvt_debug
1486: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: Calling PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW Package'
1487: , 3
1488: );
1489: pn_varen_util.pvt_debug
1490: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: START OF CALLING PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW PACKAGE'

Line 1490: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: START OF CALLING PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW PACKAGE'

1486: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: Calling PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW Package'
1487: , 3
1488: );
1489: pn_varen_util.pvt_debug
1490: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: START OF CALLING PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW PACKAGE'
1491: , 3
1492: );
1493:
1494: BEGIN

Line 1543: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: Input parameters before calling Pn_Var_Line_Defaults_Pkg.Insert_Row procedure'

1539: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: Calling Insert Row package'
1540: , 3
1541: );
1542: pn_varen_util.pvt_debug
1543: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: Input parameters before calling Pn_Var_Line_Defaults_Pkg.Insert_Row procedure'
1544: , 3
1545: );
1546: pn_varen_util.pvt_debug
1547: ( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: p_variable_rent_lines_rec_type.line_default_id : '

Line 1584: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: End of Input parameters before calling Pn_Var_Line_Defaults_Pkg.Insert_Row procedure'

1580: || g_org_id
1581: , 3
1582: );
1583: pn_varen_util.pvt_debug
1584: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: End of Input parameters before calling Pn_Var_Line_Defaults_Pkg.Insert_Row procedure'
1585: , 3
1586: );
1587: pn_var_line_defaults_pkg.insert_row
1588: (x_rowid => g_rowid

Line 1587: pn_var_line_defaults_pkg.insert_row

1583: pn_varen_util.pvt_debug
1584: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: End of Input parameters before calling Pn_Var_Line_Defaults_Pkg.Insert_Row procedure'
1585: , 3
1586: );
1587: pn_var_line_defaults_pkg.insert_row
1588: (x_rowid => g_rowid
1589: , x_line_default_id => p_variable_rent_lines_rec_type.line_default_id
1590: , x_line_num => p_variable_rent_lines_rec_type.line_num
1591: , x_var_rent_id => p_variable_rent_lines_rec_type.var_rent_id

Line 1639: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: End OF CALLING PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW PACKAGE'

1635: , x_attribute14 => p_variable_rent_lines_rec_type.attribute14
1636: , x_attribute15 => p_variable_rent_lines_rec_type.attribute15
1637: );
1638: pn_varen_util.pvt_debug
1639: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: End OF CALLING PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW PACKAGE'
1640: , 3
1641: );
1642: x_return_status := fnd_api.g_ret_sts_success;
1643: EXCEPTION

Line 1647: ( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: Exception Result of PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW PACKAGE'

1643: EXCEPTION
1644: WHEN OTHERS
1645: THEN
1646: pn_varen_util.pvt_debug
1647: ( 'PN_VAREN_PVT: Insert_Variable_Rent_Lines: Exception Result of PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW PACKAGE'
1648: || SQLERRM
1649: , 3
1650: );
1651: x_return_status := fnd_api.g_ret_sts_error;

Line 1657: -- PURPOSE : Calling pn_var_line_defaults_pkg.update_row package

1653:
1654: --------------------------------------------------------------------------------
1655: -- NAME : UPDATE_VARIABLE_RENT_LINES
1656: -- DESCRIPTION : Update records into Variable Rent Lines
1657: -- PURPOSE : Calling pn_var_line_defaults_pkg.update_row package
1658: -- INVOKED FROM :
1659: -- ARGUMENTS : P_VARIABLE_RENT_LINES_REC_TYPE IN Parameter
1660: -- : X_RETURN_STATUS OUT Parameter
1661: -- REFERENCE :

Line 1674: ('PN_VAREN_PVT: Update_Variable_Rent_Lines: Start of Input parameters before calling Pn_Var_Line_Defaults_Pkg.Update_Row procedure'

1670: IS
1671: l_not_used NUMBER DEFAULT NULL;
1672: BEGIN
1673: pn_varen_util.pvt_debug
1674: ('PN_VAREN_PVT: Update_Variable_Rent_Lines: Start of Input parameters before calling Pn_Var_Line_Defaults_Pkg.Update_Row procedure'
1675: , 3
1676: );
1677: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines : LINE_DEFAULT_ID : '
1678: || p_variable_rent_lines_rec_type.line_default_id

Line 1730: ('PN_VAREN_PVT: Update_Variable_Rent_Lines: End of Input parameters before calling Pn_Var_Line_Defaults_Pkg.Update_Row procedure'

1726: || p_variable_rent_lines_rec_type.attribute_category
1727: , 3
1728: );
1729: pn_varen_util.pvt_debug
1730: ('PN_VAREN_PVT: Update_Variable_Rent_Lines: End of Input parameters before calling Pn_Var_Line_Defaults_Pkg.Update_Row procedure'
1731: , 3
1732: );
1733: pn_var_line_defaults_pkg.update_row
1734: (x_line_default_id => p_variable_rent_lines_rec_type.line_default_id

Line 1733: pn_var_line_defaults_pkg.update_row

1729: pn_varen_util.pvt_debug
1730: ('PN_VAREN_PVT: Update_Variable_Rent_Lines: End of Input parameters before calling Pn_Var_Line_Defaults_Pkg.Update_Row procedure'
1731: , 3
1732: );
1733: pn_var_line_defaults_pkg.update_row
1734: (x_line_default_id => p_variable_rent_lines_rec_type.line_default_id
1735: , x_line_num => p_variable_rent_lines_rec_type.line_num
1736: , x_var_rent_id => p_variable_rent_lines_rec_type.var_rent_id
1737: , x_sales_type_code => p_variable_rent_lines_rec_type.sales_channel_code

Line 1769: ('PN_VAREN_PVT: Update_Variable_Rent_Lines: End of calling PN_VAR_LINE_DEFAULTS_PKG.UPDATE_ROW PACKAGE'

1765: , x_attribute14 => p_variable_rent_lines_rec_type.attribute14
1766: , x_attribute15 => p_variable_rent_lines_rec_type.attribute15
1767: );
1768: pn_varen_util.pvt_debug
1769: ('PN_VAREN_PVT: Update_Variable_Rent_Lines: End of calling PN_VAR_LINE_DEFAULTS_PKG.UPDATE_ROW PACKAGE'
1770: , 3
1771: );
1772: x_return_status := fnd_api.g_ret_sts_success;
1773: EXCEPTION

Line 1777: ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines: Exception Result of PN_VAR_LINE_DEFAULTS_PKG.UPDATE_ROW PACKAGE'

1773: EXCEPTION
1774: WHEN OTHERS
1775: THEN
1776: pn_varen_util.pvt_debug
1777: ( 'PN_VAREN_PVT: Update_Variable_Rent_Lines: Exception Result of PN_VAR_LINE_DEFAULTS_PKG.UPDATE_ROW PACKAGE'
1778: || SQLERRM
1779: , 3
1780: );
1781: x_return_status := fnd_api.g_ret_sts_error;