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.PAY_US_SQWL_ARCHIVE dependencies on FF_ARCHIVE_ITEMS_S

Line 1724: (ff_archive_items_s.nextval,

1720: CONTEXT1,
1721: VALUE,
1722: ARCHIVE_TYPE)
1723: values
1724: (ff_archive_items_s.nextval,
1725: p_user_entity_id,
1726: p_context1,
1727: p_value,
1728: 'PPA'); /* Bug:2965887 */

Line 1740: (ff_archive_items_s.currval,

1736: SEQUENCE_NO,
1737: CONTEXT,
1738: CONTEXT_ID)
1739: values
1740: (ff_archive_items_s.currval,
1741: p_sequence(i),
1742: p_context(i),
1743: p_context_id(i));
1744: end loop;

Line 2539: VALUES( ff_archive_items_s.NEXTVAL ,

2535: INSERT INTO ff_archive_items (archive_item_id,
2536: user_entity_id,
2537: context1,
2538: value)
2539: VALUES( ff_archive_items_s.NEXTVAL ,
2540: l_user_entity_id ,
2541: p_assactid ,
2542: l_sui_oh_taxable_qtd );
2543:

Line 2553: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);

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

Line 2562: VALUES (ff_archive_items_s.CURRVAL,1,l_oh_jurisdiction_code,l_context_id_jurisdiction_code);

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 */
2565: ELSIF (g_sqwl_state = 'AR') THEN
2566:

Line 2827: VALUES(ff_archive_items_s.NEXTVAL ,

2823: INSERT INTO ff_archive_items (archive_item_id,
2824: user_entity_id,
2825: context1,
2826: value)
2827: VALUES(ff_archive_items_s.NEXTVAL ,
2828: l_sui_ar_tax_user_ent_id ,
2829: p_assactid ,
2830: l_sui_ar_adj_taxable_qtd );
2831:

Line 2841: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);

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

Line 2850: VALUES (ff_archive_items_s.CURRVAL,1,l_ar_jurisdiction_code,l_context_id_jurisdiction_code);

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 */
2853: INSERT INTO ff_archive_items (archive_item_id,
2854: user_entity_id,

Line 2857: VALUES(ff_archive_items_s.NEXTVAL ,

2853: INSERT INTO ff_archive_items (archive_item_id,
2854: user_entity_id,
2855: context1,
2856: value)
2857: VALUES(ff_archive_items_s.NEXTVAL ,
2858: l_sui_ar_oos_rpt_user_ent_id,
2859: p_assactid ,
2860: l_sui_ar_oos_rpt_qtd );
2861:

Line 2866: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);

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
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);

Line 2870: VALUES (ff_archive_items_s.CURRVAL,1,l_ar_jurisdiction_code,l_context_id_jurisdiction_code);

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 */
2873: INSERT INTO ff_archive_items (archive_item_id,
2874: user_entity_id,

Line 2877: VALUES(ff_archive_items_s.NEXTVAL ,

2873: INSERT INTO ff_archive_items (archive_item_id,
2874: user_entity_id,
2875: context1,
2876: value)
2877: VALUES(ff_archive_items_s.NEXTVAL ,
2878: l_sui_ar_oos_stcd_user_ent_id,
2879: p_assactid ,
2880: l_sui_ar_oos_state_code );
2881:

Line 3030: VALUES( ff_archive_items_s.NEXTVAL ,

3026: INSERT INTO ff_archive_items (archive_item_id,
3027: user_entity_id,
3028: context1,
3029: value)
3030: VALUES( ff_archive_items_s.NEXTVAL ,
3031: l_user_entity_id ,
3032: p_assactid ,
3033: l_sui_fl_taxable_qtd );
3034:

Line 3044: VALUES (ff_archive_items_s.CURRVAL,1,taxunitid,l_context_id_tax_unit_id);

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

Line 3053: VALUES (ff_archive_items_s.CURRVAL,1,fl_jurisdiction_code,l_context_id_jurisdiction_code);

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
3056:
3057: l_user_entity_id :=get_user_entity_id('A_SCL_ASG_US_CA_WAGE_PLAN_CODE');

Line 3094: -- VALUES( ff_archive_items_s.NEXTVAL ,

3090: -- INSERT INTO ff_archive_items (archive_item_id,
3091: -- user_entity_id,
3092: -- context1,
3093: -- value)
3094: -- VALUES( ff_archive_items_s.NEXTVAL ,
3095: -- l_user_entity_id ,
3096: -- p_assactid ,
3097: -- l_wage_plan_code );
3098: --

Line 3104: -- VALUES (ff_archive_items_s.currval,

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,
3105: -- 1 ,
3106: -- l_assignment_id ,
3107: -- l_context_id_assignment_id);
3108: -- END LOOP;

Line 3133: VALUES( ff_archive_items_s.NEXTVAL ,

3129: INSERT INTO ff_archive_items (archive_item_id,
3130: user_entity_id,
3131: context1,
3132: value)
3133: VALUES( ff_archive_items_s.NEXTVAL ,
3134: l_user_entity_id ,
3135: p_assactid ,
3136: l_wage_plan_code );
3137:

Line 3142: VALUES (ff_archive_items_s.currval,

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,
3143: 1 ,
3144: asgid ,
3145: l_context_id_assignment_id);
3146:

Line 3168: VALUES( ff_archive_items_s.NEXTVAL ,

3164: INSERT INTO ff_archive_items (archive_item_id,
3165: user_entity_id,
3166: context1,
3167: value)
3168: VALUES( ff_archive_items_s.NEXTVAL ,
3169: l_user_entity_id ,
3170: p_assactid ,
3171: l_wage_plan_code );
3172:

Line 3177: VALUES (ff_archive_items_s.currval,

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,
3178: 1 ,
3179: asgid ,
3180: l_context_id_assignment_id);
3181: