APPS.PAY_PAYGTN_PKG dependencies on XDO_TEMPLATES_TL

Line 122: p_template_code xdo_templates_tl.template_code%TYPE;

118:
119: p_ppa_finder VARCHAR2(20);
120: g_payroll_action_id NUMBER;
121: l_arch_count NUMBER := 0;
122: p_template_code xdo_templates_tl.template_code%TYPE;
123: /*-- Bug#4942114 starts -- */
124: p_futa_status_count number :=0;
125: p_futa_def_bal_id number;
126: p_wc_er_liab_status_count number :=0;

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

1002: and app.application_id = fcp.application_id;
1003:
1004:
1005: -- Get template type
1006: CURSOR get_template_type(c_templ_code xdo_templates_tl.template_code%TYPE) IS
1007: SELECT template_type_code
1008: FROM xdo_templates_vl
1009: WHERE template_code = c_templ_code;
1010: --bug 6365474

Line 1045: lv_template_code xdo_templates_tl.template_code%TYPE;

1041: ln_current_request_id NUMBER;
1042: ln_application_id NUMBER;
1043: lv_proc_name VARCHAR2(100);
1044: lv_template_type xdo_templates_b.template_type_code%TYPE;
1045: lv_template_code xdo_templates_tl.template_code%TYPE;
1046: lv_app_short_name fnd_application_vl.application_short_name%TYPE;
1047:
1048:
1049: BEGIN