[Home] [Help]
253: related to bug 983094 and 101435
254:
255: 01-sep-1999 achauhan While archiving the employer data
256: add the context of pay_payroll_actions
257: to ff_archive_item_contexts.
258: 11-aug-1999 achauhan Added the call to
259: eoy_archive_gre_data in the
260: eoy_range_cursor procedure. This is
261: being done to handle the situation
1730: l_step := 2;
1731:
1732: for i in p_sequence.first .. p_sequence.last
1733: loop
1734: insert into ff_archive_item_contexts
1735: (ARCHIVE_ITEM_ID,
1736: SEQUENCE_NO,
1737: CONTEXT,
1738: CONTEXT_ID)
1750: || to_char(sqlcode));
1751: raise hr_utility.hr_error;
1752:
1753: elsif l_step = 2 then
1754: hr_utility.trace('Error while inserting into ff_archive_item_contexts'
1755: || to_char(sqlcode));
1756: raise hr_utility.hr_error;
1757:
1758: end if;
2547: INTO l_context_id_tax_unit_id
2548: FROM ff_contexts
2549: WHERE context_name = 'TAX_UNIT_ID';
2550:
2551: INSERT INTO ff_archive_item_contexts
2552: (archive_item_id,sequence_no,context,context_id)
2553: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);
2554:
2555: SELECT context_id
2556: INTO l_context_id_jurisdiction_code
2557: FROM ff_contexts
2558: WHERE context_name = 'JURISDICTION_CODE';
2559:
2560: INSERT INTO ff_archive_item_contexts
2561: (archive_item_id,sequence_no,context,context_id)
2562: VALUES (ff_archive_items_s.CURRVAL,1,l_oh_jurisdiction_code,l_context_id_jurisdiction_code);
2563:
2564: /* Added for Bug# 14097843 Starts here */
2835: INTO l_context_id_tax_unit_id
2836: FROM ff_contexts
2837: WHERE context_name = 'TAX_UNIT_ID';
2838:
2839: INSERT INTO ff_archive_item_contexts
2840: (archive_item_id,sequence_no,context,context_id)
2841: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);
2842:
2843: SELECT context_id
2844: INTO l_context_id_jurisdiction_code
2845: FROM ff_contexts
2846: WHERE context_name = 'JURISDICTION_CODE';
2847:
2848: INSERT INTO ff_archive_item_contexts
2849: (archive_item_id,sequence_no,context,context_id)
2850: VALUES (ff_archive_items_s.CURRVAL,1,l_ar_jurisdiction_code,l_context_id_jurisdiction_code);
2851:
2852: /* Archive Out of State Wages */
2860: l_sui_ar_oos_rpt_qtd );
2861:
2862: hr_utility.trace('Archived the AR Out of State Wages');
2863:
2864: INSERT INTO ff_archive_item_contexts
2865: (archive_item_id,sequence_no,context,context_id)
2866: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);
2867:
2868: INSERT INTO ff_archive_item_contexts
2864: INSERT INTO ff_archive_item_contexts
2865: (archive_item_id,sequence_no,context,context_id)
2866: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);
2867:
2868: INSERT INTO ff_archive_item_contexts
2869: (archive_item_id,sequence_no,context,context_id)
2870: VALUES (ff_archive_items_s.CURRVAL,1,l_ar_jurisdiction_code,l_context_id_jurisdiction_code);
2871:
2872: /* Archive Out of State Wages State Code */
3038: INTO l_context_id_tax_unit_id
3039: FROM ff_contexts
3040: WHERE context_name = 'TAX_UNIT_ID';
3041:
3042: INSERT INTO ff_archive_item_contexts
3043: (archive_item_id,sequence_no,context,context_id)
3044: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);
3045:
3046: SELECT context_id
3047: INTO l_context_id_jurisdiction_code
3048: FROM ff_contexts
3049: WHERE context_name = 'JURISDICTION_CODE';
3050:
3051: INSERT INTO ff_archive_item_contexts
3052: (archive_item_id,sequence_no,context,context_id)
3053: VALUES (ff_archive_items_s.CURRVAL,1,fl_jurisdiction_code,l_context_id_jurisdiction_code);
3054:
3055: ELSIF (g_sqwl_state = 'CA') THEN
3096: -- p_assactid ,
3097: -- l_wage_plan_code );
3098: --
3099: --
3100: -- INSERT INTO ff_archive_item_contexts (archive_item_id,
3101: -- sequence_no ,
3102: -- context ,
3103: -- context_id )
3104: -- VALUES (ff_archive_items_s.currval,
3134: l_user_entity_id ,
3135: p_assactid ,
3136: l_wage_plan_code );
3137:
3138: INSERT INTO ff_archive_item_contexts (archive_item_id,
3139: sequence_no ,
3140: context ,
3141: context_id )
3142: VALUES (ff_archive_items_s.currval,
3169: l_user_entity_id ,
3170: p_assactid ,
3171: l_wage_plan_code );
3172:
3173: INSERT INTO ff_archive_item_contexts (archive_item_id,
3174: sequence_no ,
3175: context ,
3176: context_id )
3177: VALUES (ff_archive_items_s.currval,