eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_RIW_WEBADI_UTILS dependencies on PQP_FLXDU_COLUMNS

Line 17: PQP_FLXDU_COLUMNS fwc,

13: ,fwc.FLXDU_SEQ_NUM
14: ,fwc.FLXDU_GROUP_NAME
15: ,fwc.FLXDU_COLUMN_XML_DATA
16: from
17: PQP_FLXDU_COLUMNS fwc,
18: bne_layout_cols blc
19: where
20: blc.INTERFACE_SEQ_NUM = fwc.FLXDU_SEQ_NUM
21: and blc.LAYOUT_CODE =c_layout_code

Line 37: FROM PQP_FLXDU_COLUMNS

33: ,FLXDU_COLUMN_XML_TAG
34: ,FLXDU_SEQ_NUM
35: ,FLXDU_GROUP_NAME
36: ,flxdu_column_xml_data
37: FROM PQP_FLXDU_COLUMNS
38: WHERE FLXDU_GROUP_NAME = c_flxdu_group_name
39: AND DISPLAY_FLAG ='N'
40: ORDER BY FLXDU_SEQ_NUM;
41:

Line 95: SELECT description INTO l_mapping_code FROM pqp_flxdu_columns where

91: ELSE
92: OPEN c_mapping_row(c_mapping_code => 'PQP_FLEXI_WEBADI_HR_MAP_KEY');
93: END IF;
94: ELSE
95: SELECT description INTO l_mapping_code FROM pqp_flxdu_columns where
96: entity_type = p_entity_name and
97: flxdu_column_name = 'MAPPING_CODE';
98: OPEN c_mapping_row(c_mapping_code => l_mapping_code);
99: END IF;

Line 183: SELECT description INTO l_mapping_code FROM pqp_flxdu_columns where

179: ELSE
180: OPEN c_mapping_cols_row(c_mapping_code => 'PQP_FLEXI_WEBADI_HR_MAP_KEY');
181: END IF;
182: ELSE
183: SELECT description INTO l_mapping_code FROM pqp_flxdu_columns where
184: entity_type = p_entity_name and
185: flxdu_column_name = 'MAPPING_CODE';
186: OPEN c_mapping_cols_row(c_mapping_code => l_mapping_code);
187: END IF;

Line 1957: -- tag in "Sample Download XML" which is stored in PQP_FLXDU_COLUMNS table

1953:
1954: --Creating content for HR
1955: l_temp_val := 'BatchId,';
1956: --$ In case of XML use EffectiveDate as Content Column name to map it to the
1957: -- tag in "Sample Download XML" which is stored in PQP_FLXDU_COLUMNS table
1958: IF (p_base_content_code = 'PQP_FLEXI_WEBADI_XML_CNT') then
1959: l_temp_val := l_temp_val||'EffectiveDate,';
1960: ELSE
1961: l_temp_val := l_temp_val||'DateOfHire,';

Line 1998: -- PQP_FLXDU_COLUMNS

1994: l_temp_val := l_temp_val ||'PersnlRelationship,ContactName,DataPumpBatchLineId,PersnlAddrInfo,AddtnlAddrDtls,FurtherPerInfo,AddtnlPersnlDtls,';
1995: l_temp_val := l_temp_val ||'AddtnlAssgDtls,Status,AssgCategory,CollectiveAgreement,EmployeeCategory,';
1996:
1997: -- For XML the content column GRE should be same as XML Tag used in
1998: -- PQP_FLXDU_COLUMNS
1999: IF (p_base_content_code = 'PQP_FLEXI_WEBADI_XML_CNT') then
2000: l_temp_val := l_temp_val || 'SoftKeySegment1,';
2001: else
2002: l_temp_val := l_temp_val || 'GRE,';

Line 2009: -- PQP_FLXDU_COLUMNS

2005: l_temp_val := l_temp_val || 'SupervisorName,DefaultCodeCombinationId,SetOfBooksId,';
2006: l_temp_val := l_temp_val ||'ApplNum,ApplAssgNum,CntgntWrkNum';
2007: --$Content for Soft Coded KFF columns
2008: -- For XML the content columns should be same as XML Tags used in
2009: -- PQP_FLXDU_COLUMNS
2010: IF (p_base_content_code = 'PQP_FLEXI_WEBADI_XML_CNT') then
2011: l_temp_val := l_temp_val || ',SoftKeySegment2,SoftKeySegment3,SoftKeySegment4,SoftKeySegment5,SoftKeySegment6,SoftKeySegment7,SoftKeySegment8,';
2012: l_temp_val := l_temp_val || 'SoftKeySegment9,SoftKeySegment10,SoftKeySegment11,SoftKeySegment12,SoftKeySegment13,SoftKeySegment14,SoftKeySegment15,SoftKeySegment16,';
2013: l_temp_val := l_temp_val || 'SoftKeySegment17,SoftKeySegment18,SoftKeySegment19,SoftKeySegment20,SoftKeySegment21,SoftKeySegment22,SoftKeySegment23,SoftKeySegment24,';

Line 2415: FROM pqp_flxdu_columns WHERE

2411: hr_utility.set_location(p_entity_name, 15);
2412:
2413: BEGIN
2414: SELECT description into l_func_type
2415: FROM pqp_flxdu_columns WHERE
2416: entity_type = p_entity_name AND
2417: flxdu_column_name = 'PQP_TYPE_FLAG';
2418: EXCEPTION
2419: WHEN NO_DATA_FOUND THEN NULL;

Line 2435: SELECT description INTO l_base_intg_code FROM PQP_FLXDU_COLUMNS WHERE

2431: FROM dual;
2432:
2433: IF p_entity_name IS NOT NULL THEN
2434: BEGIN
2435: SELECT description INTO l_base_intg_code FROM PQP_FLXDU_COLUMNS WHERE
2436: FLXDU_COLUMN_NAME = 'INTEGRATOR_CODE' and
2437: ENTITY_TYPE = p_entity_name;
2438: EXCEPTION
2439: WHEN NO_DATA_FOUND THEN

Line 2444: SELECT description INTO l_base_layout_code FROM PQP_FLXDU_COLUMNS WHERE

2440: raise no_code_found;
2441: END;
2442:
2443: BEGIN
2444: SELECT description INTO l_base_layout_code FROM PQP_FLXDU_COLUMNS WHERE
2445: FLXDU_COLUMN_NAME = 'LAYOUT_CODE' and
2446: ENTITY_TYPE = p_entity_name;
2447: EXCEPTION
2448: WHEN NO_DATA_FOUND THEN

Line 2454: SELECT description INTO l_base_content_code FROM PQP_FLXDU_COLUMNS WHERE

2450: END;
2451:
2452: IF l_search = 'T' THEN
2453: BEGIN
2454: SELECT description INTO l_base_content_code FROM PQP_FLXDU_COLUMNS WHERE
2455: FLXDU_COLUMN_NAME = 'CONTENT_CODE' and
2456: ENTITY_TYPE = p_entity_name;
2457: EXCEPTION
2458: WHEN NO_DATA_FOUND THEN

Line 2464: SELECT description INTO l_base_blnk_content_code FROM PQP_FLXDU_COLUMNS WHERE

2460: END;
2461: END IF;
2462:
2463: BEGIN
2464: SELECT description INTO l_base_blnk_content_code FROM PQP_FLXDU_COLUMNS WHERE
2465: FLXDU_COLUMN_NAME = 'BLANK_CONTENT_CODE' and
2466: ENTITY_TYPE = p_entity_name;
2467: EXCEPTION
2468: WHEN NO_DATA_FOUND THEN

Line 2473: SELECT description INTO l_base_intf_code FROM PQP_FLXDU_COLUMNS WHERE

2469: raise no_code_found;
2470: END;
2471:
2472: BEGIN
2473: SELECT description INTO l_base_intf_code FROM PQP_FLXDU_COLUMNS WHERE
2474: FLXDU_COLUMN_NAME = 'INTERFACE_CODE' and
2475: ENTITY_TYPE = p_entity_name;
2476: EXCEPTION
2477: WHEN NO_DATA_FOUND THEN