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.25.12020000.2 2012/10/23 13:47:46 ayussing ship $ */
3:
4: MAKE_ITEM CONSTANT INTEGER:= 1;
5: mrdebug CONSTANT BOOLEAN := true;

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

1675:
1676:
1677: END get_ss_date;
1678: */
1679: --modified body of msc_snapshot_pk.get_ss_date for Bug 5610482
1680: FUNCTION GET_SS_DATE (p_calendar_code VARCHAR2,
1681: p_plan_id IN NUMBER,
1682: p_owning_org_id IN NUMBER,
1683: p_owning_instance_id IN NUMBER,

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

2236: WHERE ODS.PLAN_ID = -1
2237: AND ODS.PDS_PLAN_ID = PDS.PLAN_ID
2238: AND ODS.INVENTORY_ITEM_ID = PDS.INVENTORY_ITEM_ID
2239: AND ODS.ORGANIZATION_ID = DECODE(PDS.ORGANIZATION_ID, -1,
2240: msc_snapshot_pk.get_validation_org_id(PDS.SR_INSTANCE_ID), PDS.ORGANIZATION_ID)
2241: AND ODS.SR_INSTANCE_ID = PDS.SR_INSTANCE_ID
2242: AND PDS.PLAN_ID = p_plan_id;
2243: BEGIN
2244:

Line 2373: END MSC_SNAPSHOT_PK; -- package

2369: return l_date;
2370:
2371: end;
2372:
2373: END MSC_SNAPSHOT_PK; -- package