APPS.HZ_PARTY_STAGE_SHADOW dependencies on HZ_TRANS_ATTRIBUTES_B

Line 520: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL

516: BEGIN
517: IF p_entity='PARTY' THEN
518: ctx_ddl.drop_section_group(g_schema_name || '.HZ_DQM_PARTY_GRP');
519: /* No Need for R12 SHADOW Staging
520: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
521: WHERE ENTITY_NAME='PARTY';
522: */
523: END IF;
524:

Line 528: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL

524:
525: IF p_entity='PARTY_SITES' THEN
526: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_PS_GRP');
527: /* No Need for R12 SHADOW Staging
528: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
529: WHERE ENTITY_NAME='PARTY_SITES';
530: */
531: END IF;
532:

Line 536: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL

532:
533: IF p_entity='CONTACTS' THEN
534: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_CONTACT_GRP');
535: /* No Need for R12 SHADOW Staging
536: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
537: WHERE ENTITY_NAME='CONTACTS';
538: */
539: END IF;
540:

Line 544: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL

540:
541: IF p_entity='CONTACT_POINTS' THEN
542: ctx_ddl.drop_section_group(G_SCHEMA_NAME || '.HZ_DQM_CPT_GRP');
543: /* No Need for R12 SHADOW Staging
544: UPDATE HZ_TRANS_ATTRIBUTES_B set TEMP_SECTION=NULL
545: WHERE ENTITY_NAME='CONTACT_POINTS';
546: */
547: END IF;
548: /* No Need for R12 SHADOW Staging

Line 549: log('Update of temp_section in HZ_TRANS_ATTRIBUTES_B successful for ' || p_entity);

545: WHERE ENTITY_NAME='CONTACT_POINTS';
546: */
547: END IF;
548: /* No Need for R12 SHADOW Staging
549: log('Update of temp_section in HZ_TRANS_ATTRIBUTES_B successful for ' || p_entity);
550: */
551: EXCEPTION
552: WHEN OTHERS THEN
553: log('Exception thrown. Error message is ' || SQLERRM );

Line 1633: from hz_trans_functions_vl t, hz_trans_attributes_b a

1629: FUNCTION new_primary_trans(p_entity VARCHAR2
1630: ) RETURN BOOLEAN IS
1631: cursor is_new_tran (p_entity VARCHAR2) is
1632: select 'Y'
1633: from hz_trans_functions_vl t, hz_trans_attributes_b a
1634: where a.attribute_id = t.attribute_id
1635: and ENTITY_NAME = p_entity
1636: and nvl(staged_flag, 'N') = 'N'
1637: and primary_flag = 'Y'