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 BNE_INTERFACE_COLS_B

Line 24: and blc.INTERFACE_SEQ_NUM in (Select SEQUENCE_NUM from BNE_INTERFACE_cols_b where INTERFACE_CODE =c_interface_code

20: where
21: blc.INTERFACE_SEQ_NUM = fwc.FLXDU_SEQ_NUM
22: and blc.LAYOUT_CODE =c_layout_code
23: and blc.interface_code =c_interface_code
24: and blc.INTERFACE_SEQ_NUM in (Select SEQUENCE_NUM from BNE_INTERFACE_cols_b where INTERFACE_CODE =c_interface_code
25: and DISPLAY_FLAG ='Y' AND sequence_num not in (19, 62, 93, 124, 155))
26: and fwc.DISPLAY_FLAG ='Y'
27: and fwc.entity_type in ('PERSON', 'ASSIGNMENT', 'ADDRESS')
28: order by blc.sequence_num,blc.BLOCK_ID;

Line 169: FROM BNE_INTERFACE_COLS_B

165: CURSOR c_key_flex_row (c_interface_code IN VARCHAR2
166: ,c_grp_name IN VARCHAR2)
167: IS
168: SELECT SEQUENCE_NUM
169: FROM BNE_INTERFACE_COLS_B
170: WHERE application_id = p_application_id
171: AND INTERFACE_CODE = c_interface_code
172: AND GROUP_NAME = c_grp_name
173: AND VAL_TYPE='KEYFLEX';

Line 222: FROM BNE_INTERFACE_COLS_B

218: ,LAST_UPDATE_DATE
219: ,LOV_TYPE
220: ,OFFLINE_LOV_ENABLED_FLAG
221: ,VARIABLE_DATA_TYPE_CLASS
222: FROM BNE_INTERFACE_COLS_B
223: WHERE application_id = p_application_id
224: AND INTERFACE_CODE = c_interface_code
225: AND SEQUENCE_NUM = c_interface_seq_num;
226:

Line 548: l_default_value BNE_INTERFACE_cols_b.DEFAULT_VALUE%TYPE;

544: l_rowid VARCHAR2(100);
545: l_placement_block NUMBER;
546: l_default_type VARCHAR2(20);
547: l_placement_value VARCHAR2(20);
548: l_default_value BNE_INTERFACE_cols_b.DEFAULT_VALUE%TYPE;
549: l_context_seq_num BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM%TYPE;
550: l_header_seq_num BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM%TYPE;
551: l_base_intf_code VARCHAR2(50);
552:

Line 837: Select sequence_num into l_context_seq_num from bne_interface_cols_b

833: CLOSE c_layout_cols_row;
834: ELSE
835: SELECT distinct(interface_code) into l_base_intf_code
836: from bne_layout_cols where layout_code = p_base_layout_code;
837: Select sequence_num into l_context_seq_num from bne_interface_cols_b
838: where interface_code = l_base_intf_code and
839: interface_col_name = 'P_WEBADI_CONTEXT';
840: Select sequence_num into l_header_seq_num from bne_interface_cols_b
841: where interface_code = l_base_intf_code and

Line 840: Select sequence_num into l_header_seq_num from bne_interface_cols_b

836: from bne_layout_cols where layout_code = p_base_layout_code;
837: Select sequence_num into l_context_seq_num from bne_interface_cols_b
838: where interface_code = l_base_intf_code and
839: interface_col_name = 'P_WEBADI_CONTEXT';
840: Select sequence_num into l_header_seq_num from bne_interface_cols_b
841: where interface_code = l_base_intf_code and
842: interface_col_name = 'P_WEBADI_HEADER';
843: Select sequence_num into l_bg_seq_num from bne_interface_cols_b
844: where interface_code = l_base_intf_code and

Line 843: Select sequence_num into l_bg_seq_num from bne_interface_cols_b

839: interface_col_name = 'P_WEBADI_CONTEXT';
840: Select sequence_num into l_header_seq_num from bne_interface_cols_b
841: where interface_code = l_base_intf_code and
842: interface_col_name = 'P_WEBADI_HEADER';
843: Select sequence_num into l_bg_seq_num from bne_interface_cols_b
844: where interface_code = l_base_intf_code and
845: interface_col_name = 'BUSINESS_GRP_NAME';
846:
847: OPEN c_layout_cols_row_others(c_seq_num => l_context_seq_num);

Line 1273: FROM BNE_INTERFACE_COLS_B

1269: ,LAST_UPDATE_DATE
1270: ,LOV_TYPE
1271: ,OFFLINE_LOV_ENABLED_FLAG
1272: ,VARIABLE_DATA_TYPE_CLASS
1273: FROM BNE_INTERFACE_COLS_B
1274: WHERE application_id = p_application_id
1275: AND INTERFACE_CODE = p_base_interface_code;
1276:
1277:

Line 1307: l_default_type BNE_INTERFACE_COLS_B.default_type%TYPE;

1303: no_default_layout EXCEPTION;
1304: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Interface_Col_Rows';
1305: VN_NO_INTERFACE_COL_FLAG NUMBER ;
1306: l_display VARCHAR2(1);
1307: l_default_type BNE_INTERFACE_COLS_B.default_type%TYPE;
1308: l_default_value BNE_INTERFACE_COLS_B.default_value%TYPE;
1309: l_prompt_left BNE_INTERFACE_COLS_TL.PROMPT_LEFT%TYPE;
1310: l_prompt_above BNE_INTERFACE_COLS_TL.PROMPT_ABOVE%TYPE;
1311: l_crt_upd_seq_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;

Line 1308: l_default_value BNE_INTERFACE_COLS_B.default_value%TYPE;

1304: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Interface_Col_Rows';
1305: VN_NO_INTERFACE_COL_FLAG NUMBER ;
1306: l_display VARCHAR2(1);
1307: l_default_type BNE_INTERFACE_COLS_B.default_type%TYPE;
1308: l_default_value BNE_INTERFACE_COLS_B.default_value%TYPE;
1309: l_prompt_left BNE_INTERFACE_COLS_TL.PROMPT_LEFT%TYPE;
1310: l_prompt_above BNE_INTERFACE_COLS_TL.PROMPT_ABOVE%TYPE;
1311: l_crt_upd_seq_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
1312:

Line 1311: l_crt_upd_seq_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;

1307: l_default_type BNE_INTERFACE_COLS_B.default_type%TYPE;
1308: l_default_value BNE_INTERFACE_COLS_B.default_value%TYPE;
1309: l_prompt_left BNE_INTERFACE_COLS_TL.PROMPT_LEFT%TYPE;
1310: l_prompt_above BNE_INTERFACE_COLS_TL.PROMPT_ABOVE%TYPE;
1311: l_crt_upd_seq_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
1312:
1313:
1314: BEGIN
1315: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 1316: -- Check the BNE_INTERFACE_COLS_B table to ensure that the record

1312:
1313:
1314: BEGIN
1315: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1316: -- Check the BNE_INTERFACE_COLS_B table to ensure that the record
1317: -- does not already exist
1318: VN_NO_INTERFACE_COL_FLAG := 0;
1319:
1320: SELECT sequence_num INTO l_crt_upd_seq_num FROM BNE_INTERFACE_COLS_B WHERE

Line 1320: SELECT sequence_num INTO l_crt_upd_seq_num FROM BNE_INTERFACE_COLS_B WHERE

1316: -- Check the BNE_INTERFACE_COLS_B table to ensure that the record
1317: -- does not already exist
1318: VN_NO_INTERFACE_COL_FLAG := 0;
1319:
1320: SELECT sequence_num INTO l_crt_upd_seq_num FROM BNE_INTERFACE_COLS_B WHERE
1321: INTERFACE_CODE = p_base_interface_code AND
1322: INTERFACE_COL_NAME = 'P_CRT_UPD';
1323:
1324: BEGIN

Line 1327: FROM BNE_INTERFACE_COLS_B

1323:
1324: BEGIN
1325: SELECT 1
1326: INTO VN_NO_INTERFACE_COL_FLAG
1327: FROM BNE_INTERFACE_COLS_B
1328: WHERE APPLICATION_ID = P_APPLICATION_ID
1329: AND INTERFACE_CODE = p_new_interface_code;
1330: EXCEPTION
1331: WHEN NO_DATA_FOUND THEN NULL;

Line 1405: -- Insert the required row in BNE_INTERFACE_COLS_B

1401: END IF;
1402: END IF;
1403:
1404: -- l_display := l_interface_cols_row.DISPLAY_FLAG;
1405: -- Insert the required row in BNE_INTERFACE_COLS_B
1406: INSERT INTO BNE_INTERFACE_COLS_B
1407: (APPLICATION_ID
1408: ,INTERFACE_CODE
1409: ,OBJECT_VERSION_NUMBER

Line 1406: INSERT INTO BNE_INTERFACE_COLS_B

1402: END IF;
1403:
1404: -- l_display := l_interface_cols_row.DISPLAY_FLAG;
1405: -- Insert the required row in BNE_INTERFACE_COLS_B
1406: INSERT INTO BNE_INTERFACE_COLS_B
1407: (APPLICATION_ID
1408: ,INTERFACE_CODE
1409: ,OBJECT_VERSION_NUMBER
1410: ,SEQUENCE_NUM

Line 2004: FROM BNE_INTERFACE_cols_b

2000: WHERE APPLICATION_ID = P_APPLICATION_ID
2001: AND INTERFACE_CODE = p_INTERFACE_CODE;
2002:
2003: DELETE
2004: FROM BNE_INTERFACE_cols_b
2005: WHERE APPLICATION_ID = P_APPLICATION_ID
2006: AND INTERFACE_CODE = p_INTERFACE_CODE;
2007:
2008: DELETE

Line 2623: bne_interface_cols_b intf,

2619: hr_utility.set_location('p_mapping_code: '||p_mapping_code, 5);
2620: begin
2621: select cont.sequence_num into temp_content_seq_num
2622: from bne_content_cols_b cont,
2623: bne_interface_cols_b intf,
2624: bne_mapping_lines map
2625: where
2626: map.interface_code = intf.interface_code
2627: and cont.content_code = map.content_code