[Home] [Help]
2759: * *
2760: * DESCRIPTION: *
2761: * This PL/SQL procedure is used to transform the Cost Calendars *
2762: * data in CM_CLDR_HDR_B AND CM_CLDR_DTL to GMF_CALENDAR_ASSIGNMENTS *
2763: * and GMF_PERIOD_STATUSES *
2764: * *
2765: * PARAMETERS: *
2766: * P_migration_run_id - id to use to right to migration log *
2767: * x_exception_count - Number of exceptions occurred. *
3500: p_app_short_name => 'GMA'
3501: );
3502:
3503: G_Migration_run_id := P_migration_run_id;
3504: G_Table_name := 'GMF_PERIOD_STATUSES';
3505: G_Context := 'Cost Calendar Period Statuses Migration';
3506:
3507: /********************************
3508: * Migration Started Log Message *
3519: p_app_short_name => 'GMA'
3520: );
3521:
3522: /*****************************************
3523: * Insert a row into gmf_period_statuses *
3524: *****************************************/
3525:
3526: BEGIN
3527:
3524: *****************************************/
3525:
3526: BEGIN
3527:
3528: INSERT INTO gmf_period_statuses
3529: (
3530: PERIOD_ID,
3531: LEGAL_ENTITY_ID,
3532: COST_TYPE_ID,
3566: AND h.co_code IS NOT NULL
3567: AND h.cost_mthd_code IS NOT NULL
3568: AND NOT EXISTS (
3569: SELECT 'X'
3570: FROM gmf_period_statuses p
3571: WHERE p.legal_entity_id = a.legal_entity_id
3572: AND p.cost_type_id = a.cost_type_id
3573: AND p.calendar_code = b.calendar_code
3574: AND p.period_code = b.period_code
3573: AND p.calendar_code = b.calendar_code
3574: AND p.period_code = b.period_code
3575: );
3576:
3577: UPDATE gmf_period_statuses a
3578: SET a.delete_mark = 1
3579: WHERE EXISTS (
3580: SELECT 'X'
3581: FROM gmf_calendar_assignments x
3882: = (
3883: SELECT x.cost_type_id,
3884: x.period_id,
3885: x.legal_entity_id
3886: FROM gmf_period_statuses x,
3887: cm_mthd_mst y,
3888: cm_cldr_hdr_b z,
3889: gl_plcy_mst w
3890: WHERE y.cost_mthd_code = a.cost_mthd_code
11188: )
11189: =
11190: (
11191: select gps.legal_entity_id, gps.period_id, gps.cost_type_id
11192: from gmf_period_statuses gps,
11193: cm_mthd_mst cmm,
11194: cm_cldr_hdr_b cch,
11195: gl_plcy_mst gpm
11196: where gps.calendar_code = cac.calendar_code
11382: (
11383: SELECT gps.legal_entity_id,
11384: gps.period_id,
11385: gps.cost_type_id
11386: FROM gmf_period_statuses gps,
11387: cm_mthd_mst cmm,
11388: cm_cldr_hdr_b cch,
11389: gl_plcy_mst gpm
11390: WHERE gps.calendar_code = crc.calendar_code
11693: )
11694: =
11695: (
11696: select gps.legal_entity_id, gps.period_id, gps.cost_type_id
11697: from gmf_period_statuses gps,
11698: cm_mthd_mst cmm,
11699: gl_plcy_mst gpm
11700: where gps.calendar_code = ccc.calendar_code
11701: and gpm.co_code = ccc.co_code
11923: )
11924: =
11925: (
11926: select gps.cost_type_id , gps.period_id
11927: from gmf_period_statuses gps,
11928: cm_mthd_mst cmm
11929: where gps.calendar_code = gss.crev_curr_calendar
11930: and gps.period_code = gss.crev_curr_period
11931: and cmm.cost_mthd_code = gss.crev_curr_mthd
11938: )
11939: =
11940: (
11941: select gps.cost_type_id , gps.period_id
11942: from gmf_period_statuses gps,
11943: cm_mthd_mst cmm
11944: where gps.calendar_code = gss.crev_prev_calendar
11945: and gps.period_code = gss.crev_prev_period
11946: and cmm.cost_mthd_code = gss.crev_prev_mthd
11949: ),
11950: gss.period_id
11951: = (
11952: SELECT x.period_id
11953: FROM gmf_period_statuses x
11954: WHERE x.legal_entity_id = gss.legal_entity_id
11955: AND x.cost_type_id = gss.cost_type_id
11956: AND gss.period_start_date between x.start_date and x.end_date
11957: AND gss.period_end_date between x.start_date and x.end_date