[Home] [Help]
6039: --
6040: PROCEDURE extract_item_report_format(p_user_entity_name in varchar2,
6041: p_archive_type in varchar2) IS
6042: -- This procedure inserts the necessary data into the
6043: -- PAY_REPORT_FORMAT_ITEMS_F table FOR EXTRACT ARCHIVE ITEMS ONLY.
6044: -- This distinction must be made as the procedure contains hard-
6045: -- coded data, only relevant for extract items, ie those DBI/
6046: -- User Entities starting 'X_'. Do not use this utility for
6047: -- entering other data into these tables.
6073: IF p_archive_type NOT IN ('AAP','PA','AAC') THEN
6074: RAISE invalid_archive_type;
6075: END IF;
6076: --
6077: -- Parameters validated, insert the two rows into PAY_REPORT_FORMAT_ITEMS_F,
6078: -- ensuring the inserts are re-runnable.
6079: --
6080: BEGIN
6081: -- 1. Report category F
6079: --
6080: BEGIN
6081: -- 1. Report category F
6082: --
6083: INSERT INTO pay_report_format_items_f
6084: (report_type,
6085: report_qualifier,
6086: report_category,
6087: user_entity_id,
6100: p_archive_type,
6101: 'N',
6102: NULL
6103: FROM sys.dual WHERE NOT EXISTS
6104: (SELECT 1 FROM pay_report_format_items_f
6105: WHERE report_type = 'EOY'
6106: AND report_qualifier = 'GB'
6107: AND user_entity_id = l_user_entity_id
6108: AND report_category = 'F');
6108: AND report_category = 'F');
6109: --
6110: -- 2. Report category P
6111: --
6112: INSERT INTO pay_report_format_items_f
6113: (report_type,
6114: report_qualifier,
6115: report_category,
6116: user_entity_id,
6129: p_archive_type,
6130: 'N',
6131: NULL
6132: FROM sys.dual WHERE NOT EXISTS
6133: (SELECT 1 FROM pay_report_format_items_f
6134: WHERE report_type = 'EOY'
6135: AND report_qualifier = 'GB'
6136: AND user_entity_id = l_user_entity_id
6137: AND report_category = 'P');