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_S

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 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 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 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 (