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 23: and blc.INTERFACE_SEQ_NUM in (Select SEQUENCE_NUM from BNE_INTERFACE_cols_b where INTERFACE_CODE =c_interface_code

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

Line 359: l_default_value BNE_INTERFACE_cols_b.DEFAULT_VALUE%TYPE;

355: l_rowid VARCHAR2(100);
356: l_placement_block NUMBER;
357: l_default_type VARCHAR2(20);
358: l_placement_value VARCHAR2(20);
359: l_default_value BNE_INTERFACE_cols_b.DEFAULT_VALUE%TYPE;
360: l_context_seq_num BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM%TYPE;
361: l_header_seq_num BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM%TYPE;
362: l_base_intf_code VARCHAR2(50);
363:

Line 568: Select sequence_num into l_context_seq_num from bne_interface_cols_b

564: CLOSE c_layout_cols_row;
565: ELSE
566: SELECT distinct(interface_code) into l_base_intf_code
567: from bne_layout_cols where layout_code = p_base_layout_code;
568: Select sequence_num into l_context_seq_num from bne_interface_cols_b
569: where interface_code = l_base_intf_code and
570: interface_col_name = 'P_WEBADI_CONTEXT';
571: Select sequence_num into l_header_seq_num from bne_interface_cols_b
572: where interface_code = l_base_intf_code and

Line 571: Select sequence_num into l_header_seq_num from bne_interface_cols_b

567: from bne_layout_cols where layout_code = p_base_layout_code;
568: Select sequence_num into l_context_seq_num from bne_interface_cols_b
569: where interface_code = l_base_intf_code and
570: interface_col_name = 'P_WEBADI_CONTEXT';
571: Select sequence_num into l_header_seq_num from bne_interface_cols_b
572: where interface_code = l_base_intf_code and
573: interface_col_name = 'P_WEBADI_HEADER';
574: Select sequence_num into l_bg_seq_num from bne_interface_cols_b
575: where interface_code = l_base_intf_code and

Line 574: Select sequence_num into l_bg_seq_num from bne_interface_cols_b

570: interface_col_name = 'P_WEBADI_CONTEXT';
571: Select sequence_num into l_header_seq_num from bne_interface_cols_b
572: where interface_code = l_base_intf_code and
573: interface_col_name = 'P_WEBADI_HEADER';
574: Select sequence_num into l_bg_seq_num from bne_interface_cols_b
575: where interface_code = l_base_intf_code and
576: interface_col_name = 'BUSINESS_GRP_NAME';
577:
578: OPEN c_layout_cols_row_others(c_seq_num => l_context_seq_num);

Line 1004: FROM BNE_INTERFACE_COLS_B

1000: ,LAST_UPDATE_DATE
1001: ,LOV_TYPE
1002: ,OFFLINE_LOV_ENABLED_FLAG
1003: ,VARIABLE_DATA_TYPE_CLASS
1004: FROM BNE_INTERFACE_COLS_B
1005: WHERE application_id = p_application_id
1006: AND INTERFACE_CODE = p_base_interface_code;
1007:
1008:

Line 1038: l_default_type BNE_INTERFACE_COLS_B.default_type%TYPE;

1034: no_default_layout EXCEPTION;
1035: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Interface_Col_Rows';
1036: VN_NO_INTERFACE_COL_FLAG NUMBER ;
1037: l_display VARCHAR2(1);
1038: l_default_type BNE_INTERFACE_COLS_B.default_type%TYPE;
1039: l_default_value BNE_INTERFACE_COLS_B.default_value%TYPE;
1040: l_prompt_left BNE_INTERFACE_COLS_TL.PROMPT_LEFT%TYPE;
1041: l_prompt_above BNE_INTERFACE_COLS_TL.PROMPT_ABOVE%TYPE;
1042: l_crt_upd_seq_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;

Line 1039: l_default_value BNE_INTERFACE_COLS_B.default_value%TYPE;

1035: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Interface_Col_Rows';
1036: VN_NO_INTERFACE_COL_FLAG NUMBER ;
1037: l_display VARCHAR2(1);
1038: l_default_type BNE_INTERFACE_COLS_B.default_type%TYPE;
1039: l_default_value BNE_INTERFACE_COLS_B.default_value%TYPE;
1040: l_prompt_left BNE_INTERFACE_COLS_TL.PROMPT_LEFT%TYPE;
1041: l_prompt_above BNE_INTERFACE_COLS_TL.PROMPT_ABOVE%TYPE;
1042: l_crt_upd_seq_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
1043:

Line 1042: l_crt_upd_seq_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;

1038: l_default_type BNE_INTERFACE_COLS_B.default_type%TYPE;
1039: l_default_value BNE_INTERFACE_COLS_B.default_value%TYPE;
1040: l_prompt_left BNE_INTERFACE_COLS_TL.PROMPT_LEFT%TYPE;
1041: l_prompt_above BNE_INTERFACE_COLS_TL.PROMPT_ABOVE%TYPE;
1042: l_crt_upd_seq_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
1043:
1044:
1045: BEGIN
1046: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

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

1043:
1044:
1045: BEGIN
1046: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1047: -- Check the BNE_INTERFACE_COLS_B table to ensure that the record
1048: -- does not already exist
1049: VN_NO_INTERFACE_COL_FLAG := 0;
1050:
1051: SELECT sequence_num INTO l_crt_upd_seq_num FROM BNE_INTERFACE_COLS_B WHERE

Line 1051: SELECT sequence_num INTO l_crt_upd_seq_num FROM BNE_INTERFACE_COLS_B WHERE

1047: -- Check the BNE_INTERFACE_COLS_B table to ensure that the record
1048: -- does not already exist
1049: VN_NO_INTERFACE_COL_FLAG := 0;
1050:
1051: SELECT sequence_num INTO l_crt_upd_seq_num FROM BNE_INTERFACE_COLS_B WHERE
1052: INTERFACE_CODE = p_base_interface_code AND
1053: INTERFACE_COL_NAME = 'P_CRT_UPD';
1054:
1055: BEGIN

Line 1058: FROM BNE_INTERFACE_COLS_B

1054:
1055: BEGIN
1056: SELECT 1
1057: INTO VN_NO_INTERFACE_COL_FLAG
1058: FROM BNE_INTERFACE_COLS_B
1059: WHERE APPLICATION_ID = P_APPLICATION_ID
1060: AND INTERFACE_CODE = p_new_interface_code;
1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN NULL;

Line 1122: -- Insert the required row in BNE_INTERFACE_COLS_B

1118: END IF;
1119: END IF;
1120:
1121: -- l_display := l_interface_cols_row.DISPLAY_FLAG;
1122: -- Insert the required row in BNE_INTERFACE_COLS_B
1123: INSERT INTO BNE_INTERFACE_COLS_B
1124: (APPLICATION_ID
1125: ,INTERFACE_CODE
1126: ,OBJECT_VERSION_NUMBER

Line 1123: INSERT INTO BNE_INTERFACE_COLS_B

1119: END IF;
1120:
1121: -- l_display := l_interface_cols_row.DISPLAY_FLAG;
1122: -- Insert the required row in BNE_INTERFACE_COLS_B
1123: INSERT INTO BNE_INTERFACE_COLS_B
1124: (APPLICATION_ID
1125: ,INTERFACE_CODE
1126: ,OBJECT_VERSION_NUMBER
1127: ,SEQUENCE_NUM

Line 1721: FROM BNE_INTERFACE_cols_b

1717: WHERE APPLICATION_ID = P_APPLICATION_ID
1718: AND INTERFACE_CODE = p_INTERFACE_CODE;
1719:
1720: DELETE
1721: FROM BNE_INTERFACE_cols_b
1722: WHERE APPLICATION_ID = P_APPLICATION_ID
1723: AND INTERFACE_CODE = p_INTERFACE_CODE;
1724:
1725: DELETE