[Home] [Help]
6323: --
6324: PROCEDURE extract_item_report_format(p_user_entity_name in varchar2,
6325: p_archive_type in varchar2) IS
6326: -- This procedure inserts the necessary data into the
6327: -- PAY_REPORT_FORMAT_ITEMS_F table FOR EXTRACT ARCHIVE ITEMS ONLY.
6328: -- This distinction must be made as the procedure contains hard-
6329: -- coded data, only relevant for extract items, ie those DBI/
6330: -- User Entities starting 'X_'. Do not use this utility for
6331: -- entering other data into these tables.
6357: IF p_archive_type NOT IN ('AAP','PA','AAC') THEN
6358: RAISE invalid_archive_type;
6359: END IF;
6360: --
6361: -- Parameters validated, insert the two rows into PAY_REPORT_FORMAT_ITEMS_F,
6362: -- ensuring the inserts are re-runnable.
6363: --
6364: BEGIN
6365: -- 1. Report category F
6363: --
6364: BEGIN
6365: -- 1. Report category F
6366: --
6367: INSERT INTO pay_report_format_items_f
6368: (report_type,
6369: report_qualifier,
6370: report_category,
6371: user_entity_id,
6384: p_archive_type,
6385: 'N',
6386: NULL
6387: FROM sys.dual WHERE NOT EXISTS
6388: (SELECT 1 FROM pay_report_format_items_f
6389: WHERE report_type = 'EOY'
6390: AND report_qualifier = 'GB'
6391: AND user_entity_id = l_user_entity_id
6392: AND report_category = 'F');
6392: AND report_category = 'F');
6393: --
6394: -- 2. Report category P
6395: --
6396: INSERT INTO pay_report_format_items_f
6397: (report_type,
6398: report_qualifier,
6399: report_category,
6400: user_entity_id,
6413: p_archive_type,
6414: 'N',
6415: NULL
6416: FROM sys.dual WHERE NOT EXISTS
6417: (SELECT 1 FROM pay_report_format_items_f
6418: WHERE report_type = 'EOY'
6419: AND report_qualifier = 'GB'
6420: AND user_entity_id = l_user_entity_id
6421: AND report_category = 'P');