APPS.PAY_PAYGTN_PKG dependencies on XDO_TEMPLATES_TL

Line 128: p_template_code xdo_templates_tl.template_code%TYPE;

124:
125: p_ppa_finder VARCHAR2(20);
126: g_payroll_action_id NUMBER;
127: l_arch_count NUMBER := 0;
128: p_template_code xdo_templates_tl.template_code%TYPE;
129: /*-- Bug#4942114 starts -- */
130: p_futa_status_count number :=0;
131: p_futa_def_bal_id number;
132: p_wc_er_liab_status_count number :=0;

Line 1015: CURSOR get_template_type(c_templ_code xdo_templates_tl.template_code%TYPE) IS

1011: and app.application_id = fcp.application_id;
1012:
1013:
1014: -- Get template type
1015: CURSOR get_template_type(c_templ_code xdo_templates_tl.template_code%TYPE) IS
1016: SELECT template_type_code
1017: FROM xdo_templates_vl
1018: WHERE template_code = c_templ_code;
1019: --bug 6365474

Line 1054: lv_template_code xdo_templates_tl.template_code%TYPE;

1050: ln_current_request_id NUMBER;
1051: ln_application_id NUMBER;
1052: lv_proc_name VARCHAR2(100);
1053: lv_template_type xdo_templates_b.template_type_code%TYPE;
1054: lv_template_code xdo_templates_tl.template_code%TYPE;
1055: lv_app_short_name fnd_application_vl.application_short_name%TYPE;
1056:
1057:
1058: BEGIN