DBA Data[Home] [Help]

APPS.CSC_RELATIONSHIP_PLANS_PUB dependencies on CSC_RELATIONSHIP_PLANS_PVT

Line 58: x_pvt_CSC_PLAN_HEADERS_B_REC OUT NOCOPY CSC_relationship_plans_PVT.CSC_PLAN_HEADERS_B_REC_TYPE,

54:
55: PROCEDURE CONVERT_CSC_PLAN_HEADERS_B(
56: P_CSC_PLAN_HEADERS_B_REC IN CSC_relationship_plans_PUB.CSC_PLAN_HEADERS_B_REC_TYPE,
57: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
58: x_pvt_CSC_PLAN_HEADERS_B_REC OUT NOCOPY CSC_relationship_plans_PVT.CSC_PLAN_HEADERS_B_REC_TYPE,
59: x_pvt_CSC_PARTY_ID_TBL OUT NOCOPY CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
60: )
61: IS
62:

Line 332: l_pvt_CSC_PLAN_HEADERS_B_REC CSC_RELATIONSHIP_PLANS_PVT.CSC_PLAN_HEADERS_B_REC_TYPE :=

328: )
329: IS
330: l_api_name CONSTANT VARCHAR2(30) := 'create_plan_header';
331: l_api_version_number CONSTANT NUMBER := 1.0;
332: l_pvt_CSC_PLAN_HEADERS_B_REC CSC_RELATIONSHIP_PLANS_PVT.CSC_PLAN_HEADERS_B_REC_TYPE :=
333: CSC_RELATIONSHIP_PLANS_PVT.G_MISS_CSC_PLAN_HEADERS_B_REC;
334: l_pvt_CSC_PARTY_ID_TBL CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE :=
335: CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL;
336: BEGIN

Line 333: CSC_RELATIONSHIP_PLANS_PVT.G_MISS_CSC_PLAN_HEADERS_B_REC;

329: IS
330: l_api_name CONSTANT VARCHAR2(30) := 'create_plan_header';
331: l_api_version_number CONSTANT NUMBER := 1.0;
332: l_pvt_CSC_PLAN_HEADERS_B_REC CSC_RELATIONSHIP_PLANS_PVT.CSC_PLAN_HEADERS_B_REC_TYPE :=
333: CSC_RELATIONSHIP_PLANS_PVT.G_MISS_CSC_PLAN_HEADERS_B_REC;
334: l_pvt_CSC_PARTY_ID_TBL CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE :=
335: CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL;
336: BEGIN
337: -- Standard Start of API savepoint

Line 370: CSC_relationship_plans_PVT.Create_plan_header(

366: x_pvt_CSC_PARTY_ID_TBL => l_pvt_CSC_PARTY_ID_TBL);
367:
368: -- Calling Private package : Create_PLAN_HEADERS_B
369: -- Hint : Primary key needs to be returned
370: CSC_relationship_plans_PVT.Create_plan_header(
371: P_Api_Version_Number => 1.0,
372: P_Init_Msg_List => FND_API.G_FALSE,
373: P_Commit => FND_API.G_FALSE,
374: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 567: l_pvt_CSC_PLAN_HEADERS_B_REC CSC_RELATIONSHIP_PLANS_PVT.CSC_PLAN_HEADERS_B_REC_TYPE :=

563: )
564: IS
565: l_api_name CONSTANT VARCHAR2(30) := 'update_plan_header';
566: l_api_version_number CONSTANT NUMBER := 1.0;
567: l_pvt_CSC_PLAN_HEADERS_B_REC CSC_RELATIONSHIP_PLANS_PVT.CSC_PLAN_HEADERS_B_REC_TYPE :=
568: CSC_RELATIONSHIP_PLANS_PVT.G_MISS_CSC_PLAN_HEADERS_B_REC;
569: l_pvt_CSC_PARTY_ID_TBL CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE :=
570: CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL;
571:

Line 568: CSC_RELATIONSHIP_PLANS_PVT.G_MISS_CSC_PLAN_HEADERS_B_REC;

564: IS
565: l_api_name CONSTANT VARCHAR2(30) := 'update_plan_header';
566: l_api_version_number CONSTANT NUMBER := 1.0;
567: l_pvt_CSC_PLAN_HEADERS_B_REC CSC_RELATIONSHIP_PLANS_PVT.CSC_PLAN_HEADERS_B_REC_TYPE :=
568: CSC_RELATIONSHIP_PLANS_PVT.G_MISS_CSC_PLAN_HEADERS_B_REC;
569: l_pvt_CSC_PARTY_ID_TBL CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE :=
570: CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL;
571:
572: BEGIN

Line 603: CSC_relationship_plans_pvt.update_plan_header(

599: P_PARTY_ID_TBL => P_PARTY_ID_TBL,
600: x_pvt_CSC_PLAN_HEADERS_B_REC => l_pvt_CSC_PLAN_HEADERS_B_REC,
601: x_pvt_CSC_PARTY_ID_TBL => l_pvt_CSC_PARTY_ID_TBL);
602:
603: CSC_relationship_plans_pvt.update_plan_header(
604: P_Api_Version_Number => 1.0,
605: P_Init_Msg_List => FND_API.G_FALSE,
606: P_Commit => p_commit,
607: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 684: l_pvt_CSC_PLAN_HEADERS_B_REC CSC_RELATIONSHIP_PLANS_PVT.CSC_PLAN_HEADERS_B_REC_TYPE;

680: X_Msg_Data OUT NOCOPY VARCHAR2 )
681: IS
682: l_api_name CONSTANT VARCHAR2(30) := 'Disable_Plan';
683: l_api_version_number CONSTANT NUMBER := 1.0;
684: l_pvt_CSC_PLAN_HEADERS_B_REC CSC_RELATIONSHIP_PLANS_PVT.CSC_PLAN_HEADERS_B_REC_TYPE;
685: BEGIN
686: -- Standard Start of API savepoint
687: SAVEPOINT DISABLE_PLAN_PUB;
688:

Line 706: CSC_relationship_plans_PVT.disable_plan(

702:
703: -- Initialize API return status to SUCCESS
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
705:
706: CSC_relationship_plans_PVT.disable_plan(
707: P_Api_Version_Number => 1.0,
708: P_Init_Msg_List => FND_API.G_FALSE,
709: P_Commit => p_commit,
710: P_plan_id => p_plan_id,