DBA Data[Home] [Help]

APPS.MSC_SNAPSHOT_PK dependencies on MSC_SNAPSHOT_PK

Line 1: PACKAGE BODY msc_snapshot_pk AS

1: PACKAGE BODY msc_snapshot_pk AS
2: /* $Header: MSCPSNPB.pls 120.11.12010000.2 2008/11/11 19:32:20 srpartha ship $ */
3:
4: MAKE_ITEM CONSTANT INTEGER:= 1;
5: mrdebug CONSTANT BOOLEAN := true;

Line 1653: --modified body of msc_snapshot_pk.get_ss_date for Bug 5610482

1649:
1650:
1651: END get_ss_date;
1652: */
1653: --modified body of msc_snapshot_pk.get_ss_date for Bug 5610482
1654: FUNCTION GET_SS_DATE (p_calendar_code VARCHAR2,
1655: p_plan_id IN NUMBER,
1656: p_owning_org_id IN NUMBER,
1657: p_owning_instance_id IN NUMBER,

Line 1925: msc_snapshot_pk.get_validation_org_id(PDS.SR_INSTANCE_ID), PDS.ORGANIZATION_ID)

1921: MSC_SYSTEM_ITEMS ODS
1922: WHERE ODS.PLAN_ID = -1
1923: AND ODS.INVENTORY_ITEM_ID = PDS.INVENTORY_ITEM_ID
1924: AND ODS.ORGANIZATION_ID = DECODE(PDS.ORGANIZATION_ID, -1,
1925: msc_snapshot_pk.get_validation_org_id(PDS.SR_INSTANCE_ID), PDS.ORGANIZATION_ID)
1926: AND ODS.SR_INSTANCE_ID = PDS.SR_INSTANCE_ID
1927: AND PDS.PLAN_ID = p_plan_id;
1928: BEGIN
1929:

Line 2035: END MSC_SNAPSHOT_PK; -- package

2031: return l_date;
2032:
2033: end;
2034:
2035: END MSC_SNAPSHOT_PK; -- package