APPS.PN_OPTIONS_PKG dependencies on PN_OPTIONS_ALL

Line 55: FROM pn_options_all

51: IS
52:
53: CURSOR c IS
54: SELECT ROWID
55: FROM pn_options_all
56: WHERE option_id = x_option_id ;
57:
58: CURSOR org_cur IS
59: SELECT org_id

Line 74: FROM pn_options_all PNO

70: -- We need to generate the lease change number
71: -------------------------------------------------------
72: SELECT NVL(MAX(TO_NUMBER(pno.option_num)), 0)+1
73: INTO x_option_num
74: FROM pn_options_all PNO
75: WHERE pno.lease_id = x_lease_id;
76:
77: -------------------------------------------------------
78: -- SELECT the NEXTVAL for option id

Line 95: INSERT INTO pn_options_all

91: INTO x_option_id
92: FROM DUAL;
93: END IF;
94:
95: INSERT INTO pn_options_all
96: (
97: OPTION_ID,
98: LAST_UPDATE_DATE,
99: LAST_UPDATED_BY,

Line 240: FROM pn_options_all

236: )
237: IS
238: CURSOR c1 IS
239: SELECT *
240: FROM pn_options_all
241: WHERE option_id = x_option_id
242: FOR UPDATE OF option_id NOWAIT;
243:
244: tlinfo c1%ROWTYPE;

Line 477: FROM pn_options_all

473: IS
474:
475: CURSOR c2 IS
476: SELECT *
477: FROM pn_options_all
478: WHERE option_id = x_option_id;
479:
480: recInfoForHist c2%ROWTYPE;
481: l_optionHistoryId NUMBER := NULL;

Line 602: UPDATE pn_options_all

598: );
599: END IF;
600: END IF;
601:
602: UPDATE pn_options_all
603: SET lease_id = x_lease_id,
604: lease_change_id = x_lease_change_id,
605: option_num = x_option_num,
606: option_type_code = x_option_type_code,

Line 666: DELETE FROM pn_options_all

662: BEGIN
663:
664: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.DELETE_ROW (+)');
665:
666: DELETE FROM pn_options_all
667: WHERE option_id = x_option_id;
668:
669: IF (SQL%NOTFOUND) THEN
670: RAISE NO_DATA_FOUND;