APPS.JAI_FBT_PROCESS_P dependencies on JAI_FBT_PROCESS_DATE

Line 1613: --update processing date in JAI_FBT_PROCESS_DATE for R12 new change on 06-Nov-2008, begin

1609: -----------------------------------------------------------------------------------
1610: --get journals and import into FBT repository on 28-July-2008,end
1611:
1612:
1613: --update processing date in JAI_FBT_PROCESS_DATE for R12 new change on 06-Nov-2008, begin
1614: -----------------------------------------------------------------------------------------
1615: BEGIN
1616: SELECT period_end_date
1617: INTO ld_period_end_date

Line 1618: FROM jai_fbt_process_date

1614: -----------------------------------------------------------------------------------------
1615: BEGIN
1616: SELECT period_end_date
1617: INTO ld_period_end_date
1618: FROM jai_fbt_process_date
1619: WHERE legal_entity_id = pn_legal_entity_id
1620: AND fbt_year = pn_fbt_year;
1621:
1622: IF (ld_end_date >= ld_period_end_date) THEN

Line 1623: UPDATE jai_fbt_process_date

1619: WHERE legal_entity_id = pn_legal_entity_id
1620: AND fbt_year = pn_fbt_year;
1621:
1622: IF (ld_end_date >= ld_period_end_date) THEN
1623: UPDATE jai_fbt_process_date
1624: SET period_end_date = ld_end_date
1625: WHERE legal_entity_id = pn_legal_entity_id
1626: AND fbt_year = pn_fbt_year;
1627: END IF;

Line 1631: INTO JAI_FBT_PROCESS_DATE(LEGAL_ENTITY_ID,

1627: END IF;
1628: EXCEPTION
1629: WHEN NO_DATA_FOUND THEN
1630: INSERT
1631: INTO JAI_FBT_PROCESS_DATE(LEGAL_ENTITY_ID,
1632: FBT_YEAR,
1633: PERIOD_START_DATE,
1634: PERIOD_END_DATE,
1635: CREATION_DATE,

Line 1652: --update processing date in JAI_FBT_PROCESS_DATE for R12 new change on 06-Nov-2008, end

1648: FND_GLOBAL.LOGIN_ID);
1649:
1650: END;
1651: -----------------------------------------------------------------------------------------
1652: --update processing date in JAI_FBT_PROCESS_DATE for R12 new change on 06-Nov-2008, end
1653:
1654: COMMIT;
1655:
1656: