eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AUC_DOCTYPES_PKG dependencies on PON_AUC_DOCTYPES

Line 1: PACKAGE BODY pon_auc_doctypes_pkg AS

1: PACKAGE BODY pon_auc_doctypes_pkg AS
2: /* $Header: PONDOCTB.pls 120.4 2006/10/26 22:17:40 mxfang noship $ */
3:
4:
5:

Line 7: p_doctype_id IN pon_auc_doctypes.doctype_id%TYPE

3:
4:
5:
6: PROCEDURE insert_row (
7: p_doctype_id IN pon_auc_doctypes.doctype_id%TYPE
8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE

Line 8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE

4:
5:
6: PROCEDURE insert_row (
7: p_doctype_id IN pon_auc_doctypes.doctype_id%TYPE
8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE

Line 9: ,p_scope IN pon_auc_doctypes.scope%TYPE

5:
6: PROCEDURE insert_row (
7: p_doctype_id IN pon_auc_doctypes.doctype_id%TYPE
8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE

Line 10: ,p_status IN pon_auc_doctypes.status%TYPE

6: PROCEDURE insert_row (
7: p_doctype_id IN pon_auc_doctypes.doctype_id%TYPE
8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE

Line 11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE

7: p_doctype_id IN pon_auc_doctypes.doctype_id%TYPE
8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE

Line 12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE

8: ,p_internal_name IN pon_auc_doctypes.internal_name%TYPE
9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE

Line 13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE

9: ,p_scope IN pon_auc_doctypes.scope%TYPE
10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE

Line 14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE

10: ,p_status IN pon_auc_doctypes.status%TYPE
11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE

Line 15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE

11: ,p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE
12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE

Line 16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE

12: ,p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE
13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE) IS

Line 17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE

13: ,p_created_by IN pon_auc_doctypes.created_by%TYPE
14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE) IS
21: BEGIN

Line 18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE

14: ,p_creation_date IN pon_auc_doctypes.creation_date%TYPE
15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE) IS
21: BEGIN
22:

Line 19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE

15: ,p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE
16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE) IS
21: BEGIN
22:
23:

Line 20: ,p_name IN pon_auc_doctypes_tl.name%TYPE) IS

16: ,p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE
17: ,p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE
18: ,p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE
19: ,p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE
20: ,p_name IN pon_auc_doctypes_tl.name%TYPE) IS
21: BEGIN
22:
23:
24: INSERT INTO pon_auc_doctypes

Line 24: INSERT INTO pon_auc_doctypes

20: ,p_name IN pon_auc_doctypes_tl.name%TYPE) IS
21: BEGIN
22:
23:
24: INSERT INTO pon_auc_doctypes
25: ( doctype_id
26: ,internal_name
27: ,scope
28: ,status

Line 54: INSERT INTO pon_auc_doctypes_tl doctl

50: ,p_document_type_code
51: ,p_document_subtype);
52:
53:
54: INSERT INTO pon_auc_doctypes_tl doctl
55: (doctype_id
56: ,name
57: ,language
58: ,created_by

Line 77: FROM pon_auc_doctypes_tl doctl

73: fnd_languages l
74: WHERE installed_flag in ('I', 'B')
75: AND NOT EXISTS
76: (SELECT NULL
77: FROM pon_auc_doctypes_tl doctl
78: WHERE doctl.doctype_id = p_doctype_id
79: AND doctl.language = l.language_code);
80:
81: END insert_row;

Line 84: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,

80:
81: END insert_row;
82:
83: PROCEDURE update_row (
84: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
85: p_scope IN pon_auc_doctypes.scope%TYPE,
86: p_status IN pon_auc_doctypes.status%TYPE,
87: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
88: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,

Line 85: p_scope IN pon_auc_doctypes.scope%TYPE,

81: END insert_row;
82:
83: PROCEDURE update_row (
84: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
85: p_scope IN pon_auc_doctypes.scope%TYPE,
86: p_status IN pon_auc_doctypes.status%TYPE,
87: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
88: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
89: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,

Line 86: p_status IN pon_auc_doctypes.status%TYPE,

82:
83: PROCEDURE update_row (
84: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
85: p_scope IN pon_auc_doctypes.scope%TYPE,
86: p_status IN pon_auc_doctypes.status%TYPE,
87: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
88: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
89: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
90: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,

Line 87: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,

83: PROCEDURE update_row (
84: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
85: p_scope IN pon_auc_doctypes.scope%TYPE,
86: p_status IN pon_auc_doctypes.status%TYPE,
87: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
88: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
89: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
90: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
91: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,

Line 88: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,

84: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
85: p_scope IN pon_auc_doctypes.scope%TYPE,
86: p_status IN pon_auc_doctypes.status%TYPE,
87: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
88: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
89: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
90: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
91: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
92: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,

Line 89: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,

85: p_scope IN pon_auc_doctypes.scope%TYPE,
86: p_status IN pon_auc_doctypes.status%TYPE,
87: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
88: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
89: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
90: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
91: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
92: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
93: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,

Line 90: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,

86: p_status IN pon_auc_doctypes.status%TYPE,
87: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
88: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
89: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
90: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
91: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
92: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
93: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
94: p_name IN pon_auc_doctypes_tl.name%TYPE) IS

Line 91: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,

87: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
88: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
89: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
90: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
91: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
92: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
93: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
94: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
95:

Line 92: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,

88: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
89: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
90: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
91: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
92: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
93: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
94: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
95:
96: BEGIN

Line 93: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,

89: p_last_updated_by IN pon_auc_doctypes.last_updated_by%TYPE,
90: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
91: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
92: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
93: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
94: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
95:
96: BEGIN
97:

Line 94: p_name IN pon_auc_doctypes_tl.name%TYPE) IS

90: p_last_update_date IN pon_auc_doctypes.last_update_date%TYPE,
91: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
92: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
93: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
94: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
95:
96: BEGIN
97:
98: UPDATE pon_auc_doctypes doctl

Line 98: UPDATE pon_auc_doctypes doctl

94: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
95:
96: BEGIN
97:
98: UPDATE pon_auc_doctypes doctl
99: SET scope = p_scope
100: ,status = p_status
101: ,transaction_type = p_transaction_type
102: ,message_suffix = p_message_suffix

Line 116: UPDATE pon_auc_doctypes_tl doctl

112: RAISE NO_DATA_FOUND;
113: END IF;
114:
115:
116: UPDATE pon_auc_doctypes_tl doctl
117: SET doctl.name = p_name
118: ,doctl.last_updated_by = p_last_updated_by
119: ,doctl.last_update_date = p_last_update_date
120: ,doctl.source_lang = userenv('LANG')

Line 123: FROM pon_auc_doctypes doc

119: ,doctl.last_update_date = p_last_update_date
120: ,doctl.source_lang = userenv('LANG')
121: WHERE doctype_id = (
122: SELECT doc.doctype_id
123: FROM pon_auc_doctypes doc
124: WHERE doc.internal_name = p_internal_name)
125: AND USERENV('LANG') IN ( doctl.language, doctl.source_lang);
126:
127: IF SQL%NOTFOUND

Line 137: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,

133:
134: -- Translate_row is called during NLS translation during FNDLOAD
135:
136: PROCEDURE translate_row (
137: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
138: p_name IN pon_auc_doctypes_tl.name%TYPE,
139: p_owner IN VARCHAR2,
140: p_custom_mode IN VARCHAR2,
141: p_last_update_date IN VARCHAR2

Line 138: p_name IN pon_auc_doctypes_tl.name%TYPE,

134: -- Translate_row is called during NLS translation during FNDLOAD
135:
136: PROCEDURE translate_row (
137: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
138: p_name IN pon_auc_doctypes_tl.name%TYPE,
139: p_owner IN VARCHAR2,
140: p_custom_mode IN VARCHAR2,
141: p_last_update_date IN VARCHAR2
142: ) IS

Line 158: from pon_auc_doctypes_tl

154: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
155:
156: select LAST_UPDATED_BY, LAST_UPDATE_DATE
157: into db_luby, db_ludate
158: from pon_auc_doctypes_tl
159: where doctype_id = (
160: SELECT doc.doctype_id
161: FROM pon_auc_doctypes doc
162: WHERE doc.internal_name = p_internal_name)

Line 161: FROM pon_auc_doctypes doc

157: into db_luby, db_ludate
158: from pon_auc_doctypes_tl
159: where doctype_id = (
160: SELECT doc.doctype_id
161: FROM pon_auc_doctypes doc
162: WHERE doc.internal_name = p_internal_name)
163: and userenv('LANG') = LANGUAGE;
164:
165: UPDATE pon_auc_doctypes_tl doctl

Line 165: UPDATE pon_auc_doctypes_tl doctl

161: FROM pon_auc_doctypes doc
162: WHERE doc.internal_name = p_internal_name)
163: and userenv('LANG') = LANGUAGE;
164:
165: UPDATE pon_auc_doctypes_tl doctl
166: SET doctl.name = p_name
167: ,doctl.last_updated_by = f_luby
168: ,doctl.last_update_date = f_ludate
169: ,source_lang = userenv('LANG')

Line 172: FROM pon_auc_doctypes doc

168: ,doctl.last_update_date = f_ludate
169: ,source_lang = userenv('LANG')
170: WHERE doctype_id = (
171: SELECT doc.doctype_id
172: FROM pon_auc_doctypes doc
173: WHERE doc.internal_name = p_internal_name)
174: AND USERENV('LANG') IN ( doctl.language, doctl.source_lang);
175:
176: IF SQL%NOTFOUND THEN

Line 186: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,

182: -- Load_row is called during normal insertion/updates during FNDLOAD
183: -- It UPDATEs the row if available, else INSERTs
184:
185: PROCEDURE load_row (
186: p_internal_name IN pon_auc_doctypes.internal_name%TYPE,
187: p_owner IN VARCHAR2,
188: p_last_update_date IN VARCHAR2,
189: p_custom_mode IN VARCHAR2, -- Custom mode can be FORCE
190: -- to force data to be uploaded

Line 192: p_scope IN pon_auc_doctypes.scope%TYPE,

188: p_last_update_date IN VARCHAR2,
189: p_custom_mode IN VARCHAR2, -- Custom mode can be FORCE
190: -- to force data to be uploaded
191: -- irrespective of current status
192: p_scope IN pon_auc_doctypes.scope%TYPE,
193: p_status IN pon_auc_doctypes.status%TYPE,
194: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
195: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
196: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,

Line 193: p_status IN pon_auc_doctypes.status%TYPE,

189: p_custom_mode IN VARCHAR2, -- Custom mode can be FORCE
190: -- to force data to be uploaded
191: -- irrespective of current status
192: p_scope IN pon_auc_doctypes.scope%TYPE,
193: p_status IN pon_auc_doctypes.status%TYPE,
194: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
195: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
196: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
197: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,

Line 194: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,

190: -- to force data to be uploaded
191: -- irrespective of current status
192: p_scope IN pon_auc_doctypes.scope%TYPE,
193: p_status IN pon_auc_doctypes.status%TYPE,
194: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
195: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
196: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
197: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
198: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,

Line 195: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,

191: -- irrespective of current status
192: p_scope IN pon_auc_doctypes.scope%TYPE,
193: p_status IN pon_auc_doctypes.status%TYPE,
194: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
195: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
196: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
197: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
198: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
199: p_name IN pon_auc_doctypes_tl.name%TYPE) IS

Line 196: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,

192: p_scope IN pon_auc_doctypes.scope%TYPE,
193: p_status IN pon_auc_doctypes.status%TYPE,
194: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
195: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
196: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
197: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
198: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
199: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
200:

Line 197: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,

193: p_status IN pon_auc_doctypes.status%TYPE,
194: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
195: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
196: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
197: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
198: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
199: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
200:
201:

Line 198: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,

194: p_transaction_type IN pon_auc_doctypes.transaction_type%TYPE,
195: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
196: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
197: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
198: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
199: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
200:
201:
202: -- Last update information from the file being uploaded

Line 199: p_name IN pon_auc_doctypes_tl.name%TYPE) IS

195: p_message_suffix IN pon_auc_doctypes.message_suffix%TYPE,
196: p_doctype_group_name IN pon_auc_doctypes.doctype_group_name%TYPE,
197: p_document_type_code IN pon_auc_doctypes.document_type_code%TYPE,
198: p_document_subtype IN pon_auc_doctypes.document_subtype%TYPE,
199: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
200:
201:
202: -- Last update information from the file being uploaded
203: l_f_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;

Line 203: l_f_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;

199: p_name IN pon_auc_doctypes_tl.name%TYPE) IS
200:
201:
202: -- Last update information from the file being uploaded
203: l_f_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;
204: l_f_last_update_date pon_auc_doctypes.last_update_date%TYPE;
205:
206: -- Last updated information for the row currently in the database
207: l_db_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;

Line 204: l_f_last_update_date pon_auc_doctypes.last_update_date%TYPE;

200:
201:
202: -- Last update information from the file being uploaded
203: l_f_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;
204: l_f_last_update_date pon_auc_doctypes.last_update_date%TYPE;
205:
206: -- Last updated information for the row currently in the database
207: l_db_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;
208: l_db_last_update_date pon_auc_doctypes.last_update_date%TYPE;

Line 207: l_db_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;

203: l_f_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;
204: l_f_last_update_date pon_auc_doctypes.last_update_date%TYPE;
205:
206: -- Last updated information for the row currently in the database
207: l_db_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;
208: l_db_last_update_date pon_auc_doctypes.last_update_date%TYPE;
209:
210: l_doctype_id pon_auc_doctypes.doctype_id%TYPE;
211:

Line 208: l_db_last_update_date pon_auc_doctypes.last_update_date%TYPE;

204: l_f_last_update_date pon_auc_doctypes.last_update_date%TYPE;
205:
206: -- Last updated information for the row currently in the database
207: l_db_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;
208: l_db_last_update_date pon_auc_doctypes.last_update_date%TYPE;
209:
210: l_doctype_id pon_auc_doctypes.doctype_id%TYPE;
211:
212: BEGIN

Line 210: l_doctype_id pon_auc_doctypes.doctype_id%TYPE;

206: -- Last updated information for the row currently in the database
207: l_db_last_updated_by pon_auc_doctypes.last_updated_by%TYPE;
208: l_db_last_update_date pon_auc_doctypes.last_update_date%TYPE;
209:
210: l_doctype_id pon_auc_doctypes.doctype_id%TYPE;
211:
212: BEGIN
213:
214: -- Translate owner to file_last_updated_by

Line 224: FROM pon_auc_doctypes doc

220: SELECT last_updated_by,
221: last_update_date
222: INTO l_db_last_updated_by,
223: l_db_last_update_date
224: FROM pon_auc_doctypes doc
225: WHERE doc.internal_name = p_internal_name;
226:
227: update_row (
228: p_internal_name => p_internal_name,

Line 248: SELECT pon_auc_doctypes_s.NEXTVAL

244:
245:
246: -- Need to create a new row. Get a sequence number
247:
248: SELECT pon_auc_doctypes_s.NEXTVAL
249: INTO l_doctype_id
250: FROM dual;
251:
252: insert_row (

Line 271: p_internal_name pon_auc_doctypes.internal_name%TYPE

267:
268: END load_row;
269:
270: PROCEDURE delete_row (
271: p_internal_name pon_auc_doctypes.internal_name%TYPE
272: ) IS
273:
274: l_doctype_id pon_auc_doctypes.doctype_id%TYPE;
275:

Line 274: l_doctype_id pon_auc_doctypes.doctype_id%TYPE;

270: PROCEDURE delete_row (
271: p_internal_name pon_auc_doctypes.internal_name%TYPE
272: ) IS
273:
274: l_doctype_id pon_auc_doctypes.doctype_id%TYPE;
275:
276: BEGIN
277:
278: DELETE FROM pon_auc_doctypes doc

Line 278: DELETE FROM pon_auc_doctypes doc

274: l_doctype_id pon_auc_doctypes.doctype_id%TYPE;
275:
276: BEGIN
277:
278: DELETE FROM pon_auc_doctypes doc
279: WHERE doc.internal_name = p_internal_name
280: RETURNING doctype_id
281: INTO l_doctype_id;
282:

Line 288: DELETE FROM pon_auc_doctypes_tl doctl

284: THEN
285: RAISE NO_DATA_FOUND;
286: END IF;
287:
288: DELETE FROM pon_auc_doctypes_tl doctl
289: WHERE doctl.doctype_id = l_doctype_id;
290:
291: END delete_row;
292:

Line 298: INSERT INTO PON_AUC_DOCTYPES_TL (

294: PROCEDURE add_language IS
295:
296: BEGIN
297:
298: INSERT INTO PON_AUC_DOCTYPES_TL (
299: doctype_id,
300: name,
301: language,
302: created_by,

Line 317: FROM pon_auc_doctypes_tl doctl,

313: doctl.creation_date,
314: doctl.last_updated_by,
315: doctl.last_update_date,
316: doctl.source_lang
317: FROM pon_auc_doctypes_tl doctl,
318: fnd_languages lang
319: WHERE doctl.language = USERENV('LANG')
320: AND lang.INSTALLED_FLAG in ('I', 'B')
321: AND NOT EXISTS (SELECT NULL

Line 322: FROM PON_AUC_DOCTYPES_TL doc2

318: fnd_languages lang
319: WHERE doctl.language = USERENV('LANG')
320: AND lang.INSTALLED_FLAG in ('I', 'B')
321: AND NOT EXISTS (SELECT NULL
322: FROM PON_AUC_DOCTYPES_TL doc2
323: WHERE doc2.doctype_id = doctl.doctype_id
324: AND doc2.language = lang.language_code);
325:
326: END add_language;

Line 328: END pon_auc_doctypes_pkg;

324: AND doc2.language = lang.language_code);
325:
326: END add_language;
327:
328: END pon_auc_doctypes_pkg;