APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_CONTENT_COLS_B

Line 2045: update bne_content_cols_b set read_only_flag = 'Y' where content_code =

2041: -- Date' column should be uploadable and read only.
2042: if (p_base_content_code = 'PQP_FLEXI_WEBADI_XML_CNT' OR
2043: p_base_content_code = 'PQP_FLEXI_WEBADI_CSV_CNT' OR
2044: p_base_content_code = 'PQP_FLEXI_WEBADI_HR_CNT') then
2045: update bne_content_cols_b set read_only_flag = 'Y' where content_code =
2046: l_content_out and sequence_num in (2,316,317);
2047: end if;
2048:
2049: p_content_out := l_content_out;

Line 2129: update bne_content_cols_b set read_only_flag = 'Y' where content_code in

2125:
2126: -- $ to make "Effective Date",'Assignment Effective Start Date' and "Batch Link"
2127: -- Read Only but Uploadable field at the same time
2128: -- set Read Only flag to 'Y' in Content instead of Layout
2129: update bne_content_cols_b set read_only_flag = 'Y' where content_code in
2130: (l_ce_content_out) and sequence_num in (2,317,318);
2131: update bne_content_cols_b set read_only_flag = 'Y' where content_code in
2132: (l_ce_content_out) and sequence_num = 270;
2133:

Line 2131: update bne_content_cols_b set read_only_flag = 'Y' where content_code in

2127: -- Read Only but Uploadable field at the same time
2128: -- set Read Only flag to 'Y' in Content instead of Layout
2129: update bne_content_cols_b set read_only_flag = 'Y' where content_code in
2130: (l_ce_content_out) and sequence_num in (2,317,318);
2131: update bne_content_cols_b set read_only_flag = 'Y' where content_code in
2132: (l_ce_content_out) and sequence_num = 270;
2133:
2134:
2135: --------

Line 2230: FROM bne_content_cols_b

2226:
2227: CURSOR c_content_cols_row(c_base_content_code IN VARCHAR2)
2228: IS
2229: SELECT col_name, read_only_flag, sequence_num
2230: FROM bne_content_cols_b
2231: WHERE application_id = p_application_id
2232: AND content_code = c_base_content_code
2233: ORDER BY sequence_num;
2234:

Line 2241: l_column bne_content_cols_b.col_name%TYPE;

2237: no_default_layout EXCEPTION;
2238: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
2239: l_content_out VARCHAR2(50);
2240: l_first boolean := true;
2241: l_column bne_content_cols_b.col_name%TYPE;
2242: --$ For Data Pump Correct Errors
2243: l_ce_content_out VARCHAR2(50);
2244:
2245: l_temp_val VARCHAR2(4000);

Line 2298: update bne_content_cols_b set read_only_flag = l_read_only_flag

2294: OPEN c_content_cols_row(p_base_content_code);
2295: LOOP
2296: FETCH c_content_cols_row INTO l_column, l_read_only_flag, l_sequence_num;
2297: EXIT WHEN c_content_cols_row%NOTFOUND;
2298: update bne_content_cols_b set read_only_flag = l_read_only_flag
2299: where content_code = l_content_out
2300: and sequence_num = l_sequence_num;
2301:
2302: END LOOP;