APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_INTERFACE_COLS_TL

Line 1024: FROM BNE_INTERFACE_COLS_TL

1020: ,CREATED_BY
1021: ,CREATION_DATE
1022: ,LAST_UPDATED_BY
1023: ,LAST_UPDATE_DATE
1024: FROM BNE_INTERFACE_COLS_TL
1025: WHERE application_id = p_application_id
1026: AND INTERFACE_CODE = p_base_interface_code
1027: AND SEQUENCE_NUM = c_seq_num
1028: AND LANGUAGE = user_lang;

Line 1040: l_prompt_left BNE_INTERFACE_COLS_TL.PROMPT_LEFT%TYPE;

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:
1044:

Line 1041: l_prompt_above BNE_INTERFACE_COLS_TL.PROMPT_ABOVE%TYPE;

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:
1044:
1045: BEGIN

Line 1209: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated

1205: ,l_interface_cols_row.CREATED_BY
1206: ,SYSDATE);
1207: hr_utility.set_location('The cols_b got created successfully', 79) ;
1208:
1209: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated
1210:
1211: OPEN c_interface_tl_cols_row(l_interface_cols_row.SEQUENCE_NUM , userenv('LANG'));
1212: FETCH c_interface_tl_cols_row into l_interface_tl_cols_row;
1213: hr_utility.set_location(l_interface_tl_cols_row.sequence_num, 80);

Line 1227: INSERT INTO BNE_INTERFACE_COLS_TL

1223: l_prompt_left := l_interface_tl_cols_row.PROMPT_LEFT;
1224: l_prompt_above := l_prompt_left;
1225: END IF;
1226:
1227: INSERT INTO BNE_INTERFACE_COLS_TL
1228: (APPLICATION_ID
1229: ,INTERFACE_CODE
1230: ,SEQUENCE_NUM
1231: ,LANGUAGE

Line 1716: FROM BNE_INTERFACE_cols_tl

1712: WHERE APPLICATION_ID = P_APPLICATION_ID
1713: AND LAYOUT_CODE = p_LAYOUT_CODE;
1714:
1715: DELETE
1716: FROM BNE_INTERFACE_cols_tl
1717: WHERE APPLICATION_ID = P_APPLICATION_ID
1718: AND INTERFACE_CODE = p_INTERFACE_CODE;
1719:
1720: DELETE