[Home] [Help]
14: ,fwc.FLXDU_SEQ_NUM
15: ,fwc.FLXDU_GROUP_NAME
16: ,fwc.FLXDU_COLUMN_XML_DATA
17: from
18: PQP_FLXDU_COLUMNS fwc,
19: bne_layout_cols blc
20: where
21: blc.INTERFACE_SEQ_NUM = fwc.FLXDU_SEQ_NUM
22: and blc.LAYOUT_CODE =c_layout_code
34: ,FLXDU_COLUMN_XML_TAG
35: ,FLXDU_SEQ_NUM
36: ,FLXDU_GROUP_NAME
37: ,flxdu_column_xml_data
38: FROM PQP_FLXDU_COLUMNS
39: WHERE FLXDU_GROUP_NAME = c_flxdu_group_name
40: AND DISPLAY_FLAG ='N'
41: ORDER BY FLXDU_SEQ_NUM;
42:
92: ELSE
93: OPEN c_mapping_row(c_mapping_code => 'PQP_FLEXI_WEBADI_HR_MAP_KEY');
94: END IF;
95: ELSE
96: SELECT description INTO l_mapping_code FROM pqp_flxdu_columns where
97: entity_type = p_entity_name and
98: flxdu_column_name = 'MAPPING_CODE';
99: OPEN c_mapping_row(c_mapping_code => l_mapping_code);
100:
248: ELSE
249: OPEN c_mapping_cols_row(c_mapping_code => 'PQP_FLEXI_WEBADI_HR_MAP_KEY');
250: END IF;
251: ELSE
252: SELECT description INTO l_mapping_code FROM pqp_flxdu_columns where
253: entity_type = p_entity_name and
254: flxdu_column_name = 'MAPPING_CODE';
255: OPEN c_mapping_cols_row(c_mapping_code => l_mapping_code);
256: SELECT description INTO l_interface_code FROM pqp_flxdu_columns where
252: SELECT description INTO l_mapping_code FROM pqp_flxdu_columns where
253: entity_type = p_entity_name and
254: flxdu_column_name = 'MAPPING_CODE';
255: OPEN c_mapping_cols_row(c_mapping_code => l_mapping_code);
256: SELECT description INTO l_interface_code FROM pqp_flxdu_columns where
257: entity_type = p_entity_name and
258: flxdu_column_name = 'INTERFACE_CODE';
259: l_kff_flag := FALSE;
260: END IF;
2236:
2237: --Creating content for HR
2238: l_temp_val := 'BatchId,';
2239: --$ In case of XML use EffectiveDate as Content Column name to map it to the
2240: -- tag in "Sample Download XML" which is stored in PQP_FLXDU_COLUMNS table
2241: IF (p_base_content_code = 'PQP_FLEXI_WEBADI_XML_CNT') then
2242: l_temp_val := l_temp_val||'EffectiveDate,';
2243: ELSE
2244: l_temp_val := l_temp_val||'DateOfHire,';
2277: l_temp_val := l_temp_val ||'PersnlRelationship,ContactName,DataPumpBatchLineId,PersnlAddrInfo,AddtnlAddrDtls,FurtherPerInfo,AddtnlPersnlDtls,';
2278: l_temp_val := l_temp_val ||'AddtnlAssgDtls,Status,AssgCategory,CollectiveAgreement,EmployeeCategory,';
2279:
2280: -- For XML the content column GRE should be same as XML Tag used in
2281: -- PQP_FLXDU_COLUMNS
2282: IF (p_base_content_code = 'PQP_FLEXI_WEBADI_XML_CNT') then
2283: l_temp_val := l_temp_val || 'SoftKeySegment1,';
2284: else
2285: l_temp_val := l_temp_val || 'GRE,';
2288: l_temp_val := l_temp_val || 'SupervisorName,DefaultCodeCombinationId,SetOfBooksId,';
2289: l_temp_val := l_temp_val ||'ApplNum,ApplAssgNum,CntgntWrkNum';
2290: --$Content for Soft Coded KFF columns
2291: -- For XML the content columns should be same as XML Tags used in
2292: -- PQP_FLXDU_COLUMNS
2293: IF (p_base_content_code = 'PQP_FLEXI_WEBADI_XML_CNT') then
2294: l_temp_val := l_temp_val || ',SoftKeySegment2,SoftKeySegment3,SoftKeySegment4,SoftKeySegment5,SoftKeySegment6,SoftKeySegment7,SoftKeySegment8,';
2295: l_temp_val := l_temp_val || 'SoftKeySegment9,SoftKeySegment10,SoftKeySegment11,SoftKeySegment12,SoftKeySegment13,SoftKeySegment14,SoftKeySegment15,SoftKeySegment16,';
2296: l_temp_val := l_temp_val || 'SoftKeySegment17,SoftKeySegment18,SoftKeySegment19,SoftKeySegment20,SoftKeySegment21,SoftKeySegment22,SoftKeySegment23,SoftKeySegment24,';
2755: hr_utility.set_location(p_entity_name, 15);
2756:
2757: BEGIN
2758: SELECT description into l_func_type
2759: FROM pqp_flxdu_columns WHERE
2760: entity_type = p_entity_name AND
2761: flxdu_column_name = 'PQP_TYPE_FLAG';
2762: EXCEPTION
2763: WHEN NO_DATA_FOUND THEN NULL;
2775: FROM dual;
2776:
2777: IF p_entity_name IS NOT NULL THEN
2778: BEGIN
2779: SELECT description INTO l_base_intg_code FROM PQP_FLXDU_COLUMNS WHERE
2780: FLXDU_COLUMN_NAME = 'INTEGRATOR_CODE' and
2781: ENTITY_TYPE = p_entity_name;
2782: EXCEPTION
2783: WHEN NO_DATA_FOUND THEN
2784: raise no_code_found;
2785: END;
2786:
2787: BEGIN
2788: SELECT description INTO l_base_layout_code FROM PQP_FLXDU_COLUMNS WHERE
2789: FLXDU_COLUMN_NAME = 'LAYOUT_CODE' and
2790: ENTITY_TYPE = p_entity_name;
2791: EXCEPTION
2792: WHEN NO_DATA_FOUND THEN
2794: END;
2795:
2796: IF l_search = 'T' THEN
2797: BEGIN
2798: SELECT description INTO l_base_content_code FROM PQP_FLXDU_COLUMNS WHERE
2799: FLXDU_COLUMN_NAME = 'CONTENT_CODE' and
2800: ENTITY_TYPE = p_entity_name;
2801: EXCEPTION
2802: WHEN NO_DATA_FOUND THEN
2804: END;
2805: END IF;
2806:
2807: BEGIN
2808: SELECT description INTO l_base_blnk_content_code FROM PQP_FLXDU_COLUMNS WHERE
2809: FLXDU_COLUMN_NAME = 'BLANK_CONTENT_CODE' and
2810: ENTITY_TYPE = p_entity_name;
2811: EXCEPTION
2812: WHEN NO_DATA_FOUND THEN
2813: raise no_code_found;
2814: END;
2815:
2816: BEGIN
2817: SELECT description INTO l_base_intf_code FROM PQP_FLXDU_COLUMNS WHERE
2818: FLXDU_COLUMN_NAME = 'INTERFACE_CODE' and
2819: ENTITY_TYPE = p_entity_name;
2820: EXCEPTION
2821: WHEN NO_DATA_FOUND THEN