APPS.HZ_PARTY_STAGE dependencies on HZ_TRANS_ATTRIBUTES_B

Line 721: UPDATE HZ_TRANS_ATTRIBUTES_B

717: FETCH check_ds_misc_proc INTO tmp;
718: IF check_ds_misc_proc%NOTFOUND THEN
719: l_next_misc:=l_next_misc+1;
720:
721: UPDATE HZ_TRANS_ATTRIBUTES_B
722: SET TEMP_SECTION='M'||l_next_misc
723: WHERE ATTRIBUTE_ID = ATTRS.ATTRIBUTE_ID;
724: END IF;
725: CLOSE check_ds_misc_proc;

Line 810: log('Trying to update the temp_section of HZ_TRANS_ATTRIBUTES_B for ' || p_entity);

806:
807: BEGIN
808: log('-------------------------------------');
809: log('In generate_datastore_prefs for ' || p_entity);
810: log('Trying to update the temp_section of HZ_TRANS_ATTRIBUTES_B for ' || p_entity);
811: BEGIN
812: IF p_entity='PARTY' THEN
813: ctx_ddl.drop_section_group(g_schema_name || '.HZ_DQM_PARTY_GRP');
814: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL

Line 814: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL

810: log('Trying to update the temp_section of HZ_TRANS_ATTRIBUTES_B for ' || p_entity);
811: BEGIN
812: IF p_entity='PARTY' THEN
813: ctx_ddl.drop_section_group(g_schema_name || '.HZ_DQM_PARTY_GRP');
814: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
815: WHERE ENTITY_NAME='PARTY';
816: END IF;
817:
818: IF p_entity='PARTY_SITES' THEN

Line 820: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL

816: END IF;
817:
818: IF p_entity='PARTY_SITES' THEN
819: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_PS_GRP');
820: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
821: WHERE ENTITY_NAME='PARTY_SITES';
822: END IF;
823:
824: IF p_entity='CONTACTS' THEN

Line 826: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL

822: END IF;
823:
824: IF p_entity='CONTACTS' THEN
825: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_CONTACT_GRP');
826: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
827: WHERE ENTITY_NAME='CONTACTS';
828: END IF;
829:
830: IF p_entity='CONTACT_POINTS' THEN

Line 832: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL

828: END IF;
829:
830: IF p_entity='CONTACT_POINTS' THEN
831: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_CPT_GRP');
832: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
833: WHERE ENTITY_NAME='CONTACT_POINTS';
834: END IF;
835: log('Update of HZ_TRANS_ATTRIBUTES_B successful for ' || p_entity);
836: EXCEPTION

Line 835: log('Update of HZ_TRANS_ATTRIBUTES_B successful for ' || p_entity);

831: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_CPT_GRP');
832: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
833: WHERE ENTITY_NAME='CONTACT_POINTS';
834: END IF;
835: log('Update of HZ_TRANS_ATTRIBUTES_B successful for ' || p_entity);
836: EXCEPTION
837: WHEN OTHERS THEN
838: NULL;
839: END;

Line 3007: from hz_trans_functions_vl t, hz_trans_attributes_b a

3003: FUNCTION new_primary_trans(p_entity VARCHAR2
3004: ) RETURN BOOLEAN IS
3005: cursor is_new_tran (p_entity VARCHAR2) is
3006: select 'Y'
3007: from hz_trans_functions_vl t, hz_trans_attributes_b a
3008: where a.attribute_id = t.attribute_id
3009: and ENTITY_NAME = p_entity
3010: and nvl(staged_flag, 'N') = 'N'
3011: and primary_flag = 'Y'