APPS.GCS_CONS_IMPACT_ANALYSIS_PKG dependencies on GCS_AD_TRANSACTIONS

Line 485: UPDATE gcs_ad_transactions gat

481: g_api || '.HIERARCHY_ALTERED',
482: 'Calendar Period : ' || l_cal_period_id);
483: END IF;
484:
485: UPDATE gcs_ad_transactions gat
486: SET gat.enabled_flag = 'N', gat.hidden_flag = 'N'
487: WHERE gat.transaction_date >= l_trx_date
488: AND (EXISTS
489: (SELECT 'X'

Line 502: -- Insert records into GCS_AD_TRANSACTIONS

498: AND post.cons_relationship_id = gat.post_cons_relationship_id
499: AND post.parent_entity_id = l_parent_entity_id
500: AND post.child_entity_id = l_child_entity_id));
501:
502: -- Insert records into GCS_AD_TRANSACTIONS
503: INSERT INTO GCS_AD_TRANSACTIONS
504: (ad_transaction_id,
505: pre_cons_relationship_id,
506: post_cons_relationship_id,

Line 503: INSERT INTO GCS_AD_TRANSACTIONS

499: AND post.parent_entity_id = l_parent_entity_id
500: AND post.child_entity_id = l_child_entity_id));
501:
502: -- Insert records into GCS_AD_TRANSACTIONS
503: INSERT INTO GCS_AD_TRANSACTIONS
504: (ad_transaction_id,
505: pre_cons_relationship_id,
506: post_cons_relationship_id,
507: transaction_type_code,

Line 520: (GCS_AD_TRANSACTIONS_S.NEXTVAL,

516: intermediate_percent_owned,
517: cal_period_id,
518: transaction_date)
519: VALUES
520: (GCS_AD_TRANSACTIONS_S.NEXTVAL,
521: DECODE(l_pre_cons_relationship_id,
522: -1,
523: NULL,
524: l_pre_cons_relationship_id),