APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_CONTENT_COLS_B

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

2327: -- Date' column should be uploadable and read only.
2328: if (p_base_content_code = 'PQP_FLEXI_WEBADI_XML_CNT' OR
2329: p_base_content_code = 'PQP_FLEXI_WEBADI_CSV_CNT' OR
2330: p_base_content_code = 'PQP_FLEXI_WEBADI_HR_CNT') then
2331: update bne_content_cols_b set read_only_flag = 'Y' where content_code =
2332: l_content_out and sequence_num in (2,316,317, 318);
2333: end if;
2334:
2335: p_content_out := l_content_out;

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

2411:
2412: -- $ to make "Effective Date",'Assignment Effective Start Date' and "Batch Link"
2413: -- Read Only but Uploadable field at the same time
2414: -- set Read Only flag to 'Y' in Content instead of Layout
2415: update bne_content_cols_b set read_only_flag = 'Y' where content_code in
2416: (l_ce_content_out) and sequence_num in (2,317,318, 319);
2417: update bne_content_cols_b set read_only_flag = 'Y' where content_code in
2418: (l_ce_content_out) and sequence_num = 270;
2419:

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

2413: -- Read Only but Uploadable field at the same time
2414: -- set Read Only flag to 'Y' in Content instead of Layout
2415: update bne_content_cols_b set read_only_flag = 'Y' where content_code in
2416: (l_ce_content_out) and sequence_num in (2,317,318, 319);
2417: update bne_content_cols_b set read_only_flag = 'Y' where content_code in
2418: (l_ce_content_out) and sequence_num = 270;
2419:
2420:
2421: --------

Line 2516: FROM bne_content_cols_b

2512:
2513: CURSOR c_content_cols_row(c_base_content_code IN VARCHAR2)
2514: IS
2515: SELECT col_name, read_only_flag, sequence_num
2516: FROM bne_content_cols_b
2517: WHERE application_id = p_application_id
2518: AND content_code = c_base_content_code
2519: ORDER BY sequence_num;
2520:

Line 2527: l_column bne_content_cols_b.col_name%TYPE;

2523: no_default_layout EXCEPTION;
2524: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
2525: l_content_out VARCHAR2(50);
2526: l_first boolean := true;
2527: l_column bne_content_cols_b.col_name%TYPE;
2528: --$ For Data Pump Correct Errors
2529: l_ce_content_out VARCHAR2(50);
2530:
2531: l_temp_val VARCHAR2(4000);

Line 2584: update bne_content_cols_b set read_only_flag = l_read_only_flag

2580: OPEN c_content_cols_row(p_base_content_code);
2581: LOOP
2582: FETCH c_content_cols_row INTO l_column, l_read_only_flag, l_sequence_num;
2583: EXIT WHEN c_content_cols_row%NOTFOUND;
2584: update bne_content_cols_b set read_only_flag = l_read_only_flag
2585: where content_code = l_content_out
2586: and sequence_num = l_sequence_num;
2587:
2588: END LOOP;

Line 2622: from bne_content_cols_b cont,

2618: hr_utility.set_location('p_interface_code: '||p_interface_code, 5);
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

Line 2639: update bne_content_cols_b

2635: WHEN NO_DATA_FOUND THEN NULL;
2636: end;
2637:
2638: IF temp_content_seq_num is not null then
2639: update bne_content_cols_b
2640: set read_only_flag = temp_content_ro_value
2641: where content_code = p_content_code
2642: and sequence_num = temp_content_seq_num;
2643: END IF;

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

3185:
3186: if (l_base_content_code = 'PQP_FLEXI_WEBADI_XML_CNT' OR
3187: l_base_content_code = 'PQP_FLEXI_WEBADI_CSV_CNT' OR
3188: l_base_content_code = 'PQP_FLEXI_WEBADI_HR_CNT') then
3189: update bne_content_cols_b set read_only_flag = 'Y' where content_code =
3190: l_out_content_code and sequence_num in (2,316,317,318);
3191: end if;
3192:
3193: IF p_entity_name IS NULL THEN

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

3190: l_out_content_code and sequence_num in (2,316,317,318);
3191: end if;
3192:
3193: IF p_entity_name IS NULL THEN
3194: update bne_content_cols_b set read_only_flag = 'Y' where content_code in
3195: (l_out_ce_content_code) and sequence_num in (2,317,318,270);
3196: end if;
3197:
3198: