APPS.PN_TERM_TEMPLATES_PKG dependencies on PN_TERM_TEMPLATES_ALL

Line 107: FROM pn_term_templates_all

103: )
104: IS
105: CURSOR c IS
106: SELECT ROWID
107: FROM pn_term_templates_all
108: WHERE term_template_id = x_term_template_id;
109:
110: l_return_status VARCHAR2 (30) := NULL;
111: l_rowid VARCHAR2 (18) := NULL;

Line 130: INSERT INTO pn_term_templates_all

126: END IF;
127:
128:
129: -- IF (l_return_status IS NOT NULL) THEN APP_EXCEPTION.Raise_Exception; END IF;
130: INSERT INTO pn_term_templates_all
131: (
132: term_template_id
133: ,name
134: ,set_of_books_id

Line 344: FROM pn_term_templates_all

340: --PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.update_row (+)');
341:
342: SELECT org_id
343: INTO l_org_id
344: FROM pn_term_templates_all
345: WHERE term_template_id = x_term_template_id;
346:
347: pn_term_templates_pkg.check_unq_term_template (
348: l_return_status

Line 358: UPDATE pn_term_templates_all

354: IF (l_return_status IS NOT NULL) THEN
355: app_exception.raise_exception;
356: END IF;
357:
358: UPDATE pn_term_templates_all
359: SET name = x_name
360: ,set_of_books_id = x_set_of_books_id
361: ,currency_code = x_currency_code
362: ,last_update_date = x_last_update_date

Line 487: FROM pn_term_templates_all

483: ,x_attribute15 IN VARCHAR2
484: ) IS
485: CURSOR c1 IS
486: SELECT *
487: FROM pn_term_templates_all
488: WHERE term_template_id = x_term_template_id
489: FOR UPDATE OF term_template_id NOWAIT;
490:
491: tlinfo c1%ROWTYPE;

Line 828: DELETE FROM pn_term_templates_all

824: )
825: IS
826: BEGIN
827:
828: DELETE FROM pn_term_templates_all
829: WHERE ROWID = x_rowid;
830:
831: IF (SQL%NOTFOUND) THEN
832: RAISE NO_DATA_FOUND;

Line 852: DELETE FROM pn_term_templates_all

848: )
849: IS
850: BEGIN
851:
852: DELETE FROM pn_term_templates_all
853: WHERE term_template_id = x_term_template_id;
854:
855: IF (SQL%NOTFOUND) THEN
856: RAISE NO_DATA_FOUND;

Line 882: FROM pn_term_templates_all

878: SELECT 1
879: INTO l_dummy
880: FROM DUAL
881: WHERE NOT EXISTS ( SELECT 1
882: FROM pn_term_templates_all
883: WHERE name = x_name
884: AND ((x_term_template_id IS NULL)
885: OR (term_template_id <> x_term_template_id)
886: AND org_id = x_org_id