APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on FII_AR_PARTIES_LEVEL1_GT

Line 465: FROM FII_AR_Parties_Level1_GT GROUP BY Party_ID;

461: l_start_date_temp DATE;
462:
463: CURSOR Party_Delta IS
464: SELECT Party_ID
465: FROM FII_AR_Parties_Level1_GT GROUP BY Party_ID;
466:
467: l_max_batch_party_id NUMBER(15,0);
468: l_prev_max_batch_party_id NUMBER(15,0);
469: l_max_cust_account_id NUMBER(15,0);

Line 614: g_state := 'Populate FII_AR_Parties_Delta_GT with potentially deleted parties and FII_AR_Parties_Level1_GT with potentially new or updated parent parties.';

610: END IF;
611:
612: IF g_hierarchy_type IS NOT NULL THEN
613:
614: g_state := 'Populate FII_AR_Parties_Delta_GT with potentially deleted parties and FII_AR_Parties_Level1_GT with potentially new or updated parent parties.';
615: if g_debug_flag = 'Y' then
616: FII_UTIL.put_line(g_state);
617: FII_UTIL.start_timer;
618: end if;

Line 639: THEN INTO FII_AR_Parties_Level1_GT (

635: Level_Number)
636: VALUES (Child_ID, 2, 0)
637: WHEN (Effective_End_Date NOT BETWEEN g_last_load_date AND g_sysdate
638: AND Level_Number = 1)
639: THEN INTO FII_AR_Parties_Level1_GT (
640: Party_ID)
641: VALUES (Child_ID)
642: SELECT Child_ID,
643: Level_Number,

Line 656: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_Parties_Delta_GT and FII_AR_Parties_Level1_GT');

652: OR Effective_Start_Date BETWEEN g_last_load_date AND g_sysdate
653: OR Last_Update_Date BETWEEN g_last_load_date AND g_sysdate);
654:
655: if g_debug_flag = 'Y' then
656: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_Parties_Delta_GT and FII_AR_Parties_Level1_GT');
657: FII_UTIL.stop_timer;
658: FII_UTIL.print_timer('Duration');
659: end if;
660:

Line 661: g_state := 'Populate FII_AR_Parties_Level2_GT while looping through FII_AR_Parties_Level1_GT.';

657: FII_UTIL.stop_timer;
658: FII_UTIL.print_timer('Duration');
659: end if;
660:
661: g_state := 'Populate FII_AR_Parties_Level2_GT while looping through FII_AR_Parties_Level1_GT.';
662: if g_debug_flag = 'Y' then
663: FII_UTIL.put_line(g_state);
664: FII_UTIL.start_timer;
665: end if;