APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on XDO_TEMPLATES_B

Line 29: data_source_code in table xdo_templates_b, this function needs one

25: Whenever any new concurrent programs is required to be added in this
26: category i.e if any new conc programs is decided to have the flexibility
27: of registering custom template, please edit the function GET_NAME.
28: If the Concurrent program's short name differs from the corresponding
29: data_source_code in table xdo_templates_b, this function needs one
30: 'elsif' clause to be added for that new concurrent program.
31:
32: Change History
33:

Line 62: FROM xdo_templates_b xb, xdo_templates_tl xtl

58:
59: CURSOR csr_temp_code_dtls(p_template_code IN VARCHAR,
60: p_concurrent_prog IN VARCHAR) IS
61: SELECT xtl.template_code, xtl.template_name, xb.template_type_code
62: FROM xdo_templates_b xb, xdo_templates_tl xtl
63: WHERE xb.template_code = xtl.template_code
64: AND xb.application_short_name = xtl.application_short_name
65: AND xtl.application_short_name = 'PAY'
66: AND xb.template_status = 'E'

Line 121: lv_template_type_code xdo_templates_b.template_type_code%TYPE;

117: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;
118: lv_meaning fnd_common_lookups.meaning%TYPE;
119: lv_template_code xdo_templates_tl.template_code%TYPE;
120: lv_template_name xdo_templates_tl.template_name%TYPE;
121: lv_template_type_code xdo_templates_b.template_type_code%TYPE;
122: lv_rg_short_name fnd_common_lookups.description%TYPE;
123: lv_legislation_code hr_organization_information.org_information9%TYPE;
124: ln_report_group_id pay_report_groups.report_group_id%TYPE;
125: ln_report_category_id pay_report_categories.report_category_id%TYPE;

Line 504: -- xdo_templates_b

500:
501: FUNCTION GET_NAME(p_conc_prog IN VARCHAR2)
502: -- This function accepts the short_name of a concurrent program
503: -- and returns the corresponding data_source_code in table
504: -- xdo_templates_b
505: RETURN VARCHAR2
506: IS
507:
508: BEGIN