APPS.FND_SEQ_CATEGORIES_PKG dependencies on FND_DOC_SEQUENCE_CATEGORIES

Line 15: FROM fnd_doc_sequence_categories fcat

11:
12: Dummy VARCHAR2(10);
13: CURSOR c_cat IS
14: SELECT 'Duplicate'
15: FROM fnd_doc_sequence_categories fcat
16: WHERE fcat.code = x_category_code
17: AND fcat.application_id = x_applicatio_id;
18: BEGIN
19: OPEN c_cat;

Line 73: INSERT INTO fnd_doc_sequence_categories (

69: x_last_update_login NUMBER ) IS
70:
71: BEGIN
72: IF (is_dublicate_cat(x_application_id,x_category_code)=0) THEN
73: INSERT INTO fnd_doc_sequence_categories (
74: application_id, last_update_date, last_updated_by,
75: code, name, description,
76: table_name, created_by, creation_date,
77: last_update_login )

Line 105: cat FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;

101: x_category_code VARCHAR2,
102: x_category_name VARCHAR2,
103: x_description VARCHAR2,
104: x_last_updated_by NUMBER ) IS
105: cat FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;
106:
107: BEGIN
108: IF is_dublicate_cat(x_application_id,x_category_code)=1 THEN
109: UPDATE fnd_doc_sequence_categories fcat

Line 109: UPDATE fnd_doc_sequence_categories fcat

105: cat FND_DOC_SEQUENCE_CATEGORIES.code%TYPE;
106:
107: BEGIN
108: IF is_dublicate_cat(x_application_id,x_category_code)=1 THEN
109: UPDATE fnd_doc_sequence_categories fcat
110: SET fcat.name = x_category_name,
111: fcat.description = x_description,
112: fcat.last_update_date = sysdate,
113: fcat.last_updated_by = x_last_updated_by