[Home] [Help]
29: Whenever any new concurrent programs is required to be added in this
30: category i.e if any new conc programs is decided to have the flexibility
31: of registering custom template, please edit the function GET_NAME.
32: If the Concurrent program's short name differs from the corresponding
33: data_source_code in table xdo_templates_b, this function needs one
34: 'elsif' clause to be added for that new concurrent program.
35:
36: Change History
37:
67:
68: CURSOR csr_temp_code_dtls(p_template_code IN VARCHAR,
69: p_concurrent_prog IN VARCHAR) IS
70: SELECT xtl.template_code, xtl.template_name, xb.template_type_code
71: FROM xdo_templates_b xb, xdo_templates_tl xtl
72: WHERE xb.template_code = xtl.template_code
73: AND xb.application_short_name = xtl.application_short_name
74: AND xtl.application_short_name IN ('PAY', 'PER') /* Bug 8716056 */
75: AND xb.template_status = 'E'
126: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;
127: lv_meaning fnd_common_lookups.meaning%TYPE;
128: lv_template_code xdo_templates_tl.template_code%TYPE;
129: lv_template_name xdo_templates_tl.template_name%TYPE;
130: lv_template_type_code xdo_templates_b.template_type_code%TYPE;
131: lv_rg_short_name fnd_common_lookups.description%TYPE;
132: lv_legislation_code hr_organization_information.org_information9%TYPE;
133: ln_report_group_id pay_report_groups.report_group_id%TYPE;
134: ln_report_category_id pay_report_categories.report_category_id%TYPE;
509:
510: FUNCTION GET_NAME(p_conc_prog IN VARCHAR2)
511: -- This function accepts the short_name of a concurrent program
512: -- and returns the corresponding data_source_code in table
513: -- xdo_templates_b
514: RETURN VARCHAR2
515: IS
516:
517: BEGIN