eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_RELATIONSHIP_PLANS_PUB dependencies on CSC_CUST_PLANS_PVT

Line 57: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,

53: -- End of Comments
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

Line 59: x_pvt_CSC_PARTY_ID_TBL OUT NOCOPY CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE

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:
63: CURSOR C_Get_Lookup_Code(X_Lookup_Type VARCHAR2, X_Meaning VARCHAR2) IS

Line 247: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,

243: P_ATTRIBUTE_CATEGORY IN VARCHAR2,
244: P_OBJECT_VERSION_NUMBER IN NUMBER ,
245: P_DESCRIPTION IN VARCHAR2,
246: P_NAME IN VARCHAR2,
247: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
248: X_PLAN_ID OUT NOCOPY NUMBER,
249: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
250: X_Return_Status OUT NOCOPY VARCHAR2,
251: X_Msg_Count OUT NOCOPY NUMBER,

Line 322: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,

318: P_Commit IN VARCHAR2,
319: P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
320: P_DESCRIPTION IN VARCHAR2,
321: P_NAME IN VARCHAR2,
322: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
323: X_PLAN_ID OUT NOCOPY NUMBER,
324: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
325: X_Return_Status OUT NOCOPY VARCHAR2,
326: X_Msg_Count OUT NOCOPY NUMBER,

Line 334: l_pvt_CSC_PARTY_ID_TBL CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE :=

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
338: SAVEPOINT create_plan_header_pub;

Line 335: CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL;

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
338: SAVEPOINT create_plan_header_pub;
339:

Line 485: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,

481: P_ATTRIBUTE_CATEGORY IN VARCHAR2,
482: P_OBJECT_VERSION_NUMBER IN NUMBER ,
483: P_DESCRIPTION IN VARCHAR2,
484: P_NAME IN VARCHAR2,
485: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
486: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
487: X_Return_Status OUT NOCOPY VARCHAR2,
488: X_Msg_Count OUT NOCOPY NUMBER,
489: X_Msg_Data OUT NOCOPY VARCHAR2

Line 558: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,

554: P_Commit IN VARCHAR2,
555: P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
556: P_DESCRIPTION IN VARCHAR2,
557: P_NAME IN VARCHAR2,
558: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
559: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
560: X_Return_Status OUT NOCOPY VARCHAR2,
561: X_Msg_Count OUT NOCOPY NUMBER,
562: X_Msg_Data OUT NOCOPY VARCHAR2

Line 569: l_pvt_CSC_PARTY_ID_TBL CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE :=

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
573: -- Standard Start of API savepoint

Line 570: CSC_CUST_PLANS_PVT.G_MISS_PARTY_ID_TBL;

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
573: -- Standard Start of API savepoint
574: SAVEPOINT update_plan_header_pub;