APPS.PQP_RIW_WEBADI_UTILS dependencies on PQP_FLXDU_FUNC_ATTRIBUTES

Line 1741: --$ Update Metadata ( FLXDU_FUNC_INTEGRATOR_CODE in PQP_FLXDU_FUNC_ATTRIBUTES)

1737: ,X_LAST_UPDATE_DATE => sysdate
1738: ,X_LAST_UPDATED_BY => l_function_row.CREATED_BY
1739: ,X_LAST_UPDATE_LOGIN => 0);
1740:
1741: --$ Update Metadata ( FLXDU_FUNC_INTEGRATOR_CODE in PQP_FLXDU_FUNC_ATTRIBUTES)
1742: update PQP_FLXDU_FUNC_ATTRIBUTES
1743: set FLXDU_FUNC_INTEGRATOR_CODE = p_new_interface_code
1744: where flxdu_func_attribute_id = l_function_row.FUNCTION_ID
1745: and flxdu_func_name = l_function_row.FUNCTION_NAME;

Line 1742: update PQP_FLXDU_FUNC_ATTRIBUTES

1738: ,X_LAST_UPDATED_BY => l_function_row.CREATED_BY
1739: ,X_LAST_UPDATE_LOGIN => 0);
1740:
1741: --$ Update Metadata ( FLXDU_FUNC_INTEGRATOR_CODE in PQP_FLXDU_FUNC_ATTRIBUTES)
1742: update PQP_FLXDU_FUNC_ATTRIBUTES
1743: set FLXDU_FUNC_INTEGRATOR_CODE = p_new_interface_code
1744: where flxdu_func_attribute_id = l_function_row.FUNCTION_ID
1745: and flxdu_func_name = l_function_row.FUNCTION_NAME;
1746: ELSE

Line 1829: update PQP_FLXDU_FUNC_ATTRIBUTES set flxdu_func_xml_data = poXML

1825: END IF;
1826:
1827: IF p_action_type = 'Update' THEN
1828:
1829: update PQP_FLXDU_FUNC_ATTRIBUTES set flxdu_func_xml_data = poXML
1830: where flxdu_func_attribute_id = l_function_row.FUNCTION_ID
1831: and flxdu_func_name = l_function_row.FUNCTION_NAME;
1832: ELSE
1833: INSERT INTO PQP_FLXDU_FUNC_ATTRIBUTES

Line 1833: INSERT INTO PQP_FLXDU_FUNC_ATTRIBUTES

1829: update PQP_FLXDU_FUNC_ATTRIBUTES set flxdu_func_xml_data = poXML
1830: where flxdu_func_attribute_id = l_function_row.FUNCTION_ID
1831: and flxdu_func_name = l_function_row.FUNCTION_NAME;
1832: ELSE
1833: INSERT INTO PQP_FLXDU_FUNC_ATTRIBUTES
1834: (FLXDU_FUNC_ATTRIBUTE_ID
1835: ,FLXDU_FUNC_NAME
1836: ,FLXDU_FUNC_SOURCE_TYPE
1837: ,FLXDU_FUNC_INTEGRATOR_CODE

Line 3321: FROM PQP_FLXDU_FUNC_ATTRIBUTES

3317: ,object_version_number
3318: FROM per_ri_setup_sub_tasks
3319: WHERE setup_sub_task_code --$ setup_sub_task_action
3320: = (SELECT FLXDU_FUNC_NAME
3321: FROM PQP_FLXDU_FUNC_ATTRIBUTES
3322: WHERE FLXDU_FUNC_ATTRIBUTE_ID = p_function_id );
3323:
3324: --$ To fetch Interface Code from function id
3325: CURSOR csr_get_interface_code IS

Line 3327: PQP_FLXDU_FUNC_ATTRIBUTES where FLXDU_FUNC_ATTRIBUTE_ID = p_function_id;

3323:
3324: --$ To fetch Interface Code from function id
3325: CURSOR csr_get_interface_code IS
3326: select flxdu_func_integrator_code from
3327: PQP_FLXDU_FUNC_ATTRIBUTES where FLXDU_FUNC_ATTRIBUTE_ID = p_function_id;
3328:
3329: l_ENTRY_SEQUENCE NUMBER;
3330: l_menu_id NUMBER;
3331: l_count NUMBER;

Line 3380: FROM PQP_FLXDU_FUNC_ATTRIBUTES

3376: ,p_object_version_number => l_ovn);
3377: END IF;
3378:
3379: DELETE
3380: FROM PQP_FLXDU_FUNC_ATTRIBUTES
3381: WHERE FLXDU_FUNC_ATTRIBUTE_ID = p_function_id;
3382:
3383: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(
3384: X_FUNCTION_ID => p_function_id);