APPS.HZ_MIXNM_WEBUI_UTILITY dependencies on HZ_THIRDPARTY_RULE

Line 862: INSERT INTO hz_thirdparty_rule (

858: IF p_rule_exists = 'N' THEN
859:
860: -- new rule. Insert.
861: FORALL i IN 1..l_entity_attr_id_tab.COUNT
862: INSERT INTO hz_thirdparty_rule (
863: entity_attr_id,
864: overwrite_flag,
865: created_by,
866: creation_date,

Line 888: DELETE hz_thirdparty_rule

884:
885: -- old rule. Update.
886: FOR i IN 1..l_entity_attr_id_tab.COUNT LOOP
887: IF l_flag_tab(i) = 'N' THEN
888: DELETE hz_thirdparty_rule
889: WHERE entity_attr_id = l_entity_attr_id_tab(i)
890: AND orig_system = l_os_tab(i);
891: ELSIF l_flag_tab(i) = 'Y' THEN
892: INSERT INTO hz_thirdparty_rule (

Line 892: INSERT INTO hz_thirdparty_rule (

888: DELETE hz_thirdparty_rule
889: WHERE entity_attr_id = l_entity_attr_id_tab(i)
890: AND orig_system = l_os_tab(i);
891: ELSIF l_flag_tab(i) = 'Y' THEN
892: INSERT INTO hz_thirdparty_rule (
893: entity_attr_id,
894: overwrite_flag,
895: created_by,
896: creation_date,

Line 915: UPDATE hz_thirdparty_rule

911: );
912: END IF;
913: END LOOP;
914: /*
915: UPDATE hz_thirdparty_rule
916: SET overwrite_flag = l_flag_tab(i),
917: last_update_login = hz_utility_v2pub.last_update_login,
918: last_update_date = SYSDATE,
919: last_updated_by = hz_utility_v2pub.last_updated_by