APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_INTERFACE_COLS_TL

Line 1293: FROM BNE_INTERFACE_COLS_TL

1289: ,CREATED_BY
1290: ,CREATION_DATE
1291: ,LAST_UPDATED_BY
1292: ,LAST_UPDATE_DATE
1293: FROM BNE_INTERFACE_COLS_TL
1294: WHERE application_id = p_application_id
1295: AND INTERFACE_CODE = p_base_interface_code
1296: AND SEQUENCE_NUM = c_seq_num
1297: AND LANGUAGE = user_lang;

Line 1309: l_prompt_left BNE_INTERFACE_COLS_TL.PROMPT_LEFT%TYPE;

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

Line 1310: l_prompt_above BNE_INTERFACE_COLS_TL.PROMPT_ABOVE%TYPE;

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:
1313:
1314: BEGIN

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

1488: ,l_interface_cols_row.CREATED_BY
1489: ,SYSDATE);
1490: hr_utility.set_location('The cols_b got created successfully', 79) ;
1491:
1492: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated
1493:
1494: OPEN c_interface_tl_cols_row(l_interface_cols_row.SEQUENCE_NUM , userenv('LANG'));
1495: FETCH c_interface_tl_cols_row into l_interface_tl_cols_row;
1496: hr_utility.set_location(l_interface_tl_cols_row.sequence_num, 80);

Line 1510: INSERT INTO BNE_INTERFACE_COLS_TL

1506: l_prompt_left := l_interface_tl_cols_row.PROMPT_LEFT;
1507: l_prompt_above := l_prompt_left;
1508: END IF;
1509:
1510: INSERT INTO BNE_INTERFACE_COLS_TL
1511: (APPLICATION_ID
1512: ,INTERFACE_CODE
1513: ,SEQUENCE_NUM
1514: ,LANGUAGE

Line 1999: FROM BNE_INTERFACE_cols_tl

1995: WHERE APPLICATION_ID = P_APPLICATION_ID
1996: AND LAYOUT_CODE = p_LAYOUT_CODE;
1997:
1998: DELETE
1999: FROM BNE_INTERFACE_cols_tl
2000: WHERE APPLICATION_ID = P_APPLICATION_ID
2001: AND INTERFACE_CODE = p_INTERFACE_CODE;
2002:
2003: DELETE