DBA Data[Home] [Help]

APPS.PN_LEASE_PVT dependencies on PN_OPTIONS_ALL

Line 10554: l_option_id PN_OPTIONS_ALL.option_id%type;

10550: IS
10551: l_index BINARY_INTEGER;
10552: t_index BINARY_INTEGER;
10553: l_row_id VARCHAR2(100) ;
10554: l_option_id PN_OPTIONS_ALL.option_id%type;
10555: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
10556: x_msg_count NUMBER ;
10557: x_msg_data VARCHAR2(2000) ;
10558: BEGIN

Line 10770: FROM PN_OPTIONS_ALL

10766: option_area_change,
10767: option_reference,
10768: option_notice_reqd,
10769: option_comments
10770: FROM PN_OPTIONS_ALL
10771: where option_id = p_option_id;
10772: lcu_option_rec c_option%ROWTYPE;
10773: BEGIN
10774: l_return_status := fnd_api.g_ret_sts_success ;

Line 11209: l_option_id PN_OPTIONS_ALL.OPTION_ID%type;

11205: )
11206: IS
11207: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
11208: l_index BINARY_INTEGER;
11209: l_option_id PN_OPTIONS_ALL.OPTION_ID%type;
11210: x_msg_count NUMBER ;
11211: x_msg_data VARCHAR2(2000) ;
11212:
11213: l_error_count_uerr NUMBER := 0;