APPS.CSC_RELATIONSHIP_PLANS_PVT dependencies on CSC_PLAN_HEADERS_B_PKG

Line 562: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Insert_Row)

558: if ( p_description <> FND_API.G_MISS_CHAR ) then
559: l_description:= p_description;
560: end if;
561:
562: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Insert_Row)
563: x_plan_id := p_csc_plan_headers_b_rec.plan_id;
564: CSC_PLAN_HEADERS_B_PKG.Insert_Row(
565: px_PLAN_ID => x_plan_id,
566: p_ORIGINAL_PLAN_ID => l_ins_plan_headers_b_rec.ORIGINAL_PLAN_ID,

Line 564: CSC_PLAN_HEADERS_B_PKG.Insert_Row(

560: end if;
561:
562: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Insert_Row)
563: x_plan_id := p_csc_plan_headers_b_rec.plan_id;
564: CSC_PLAN_HEADERS_B_PKG.Insert_Row(
565: px_PLAN_ID => x_plan_id,
566: p_ORIGINAL_PLAN_ID => l_ins_plan_headers_b_rec.ORIGINAL_PLAN_ID,
567: p_PLAN_GROUP_CODE => l_ins_plan_headers_b_rec.PLAN_GROUP_CODE,
568: p_START_DATE_ACTIVE => l_ins_plan_headers_b_rec.START_DATE_ACTIVE,

Line 865: CSC_PLAN_HEADERS_B_PKG.LOCK_ROW(

861:
862: -- Initialize API return status to SUCCESS
863: x_return_status := FND_API.G_RET_STS_SUCCESS;
864:
865: CSC_PLAN_HEADERS_B_PKG.LOCK_ROW(
866: P_PLAN_ID => p_csc_plan_headers_b_rec.plan_id,
867: P_OBJECT_VERSION_NUMBER => p_csc_plan_headers_b_rec.OBJECT_VERSION_NUMBER );
868:
869: Open c_get_csc_plan_headers( p_csc_plan_headers_b_rec.PLAN_ID );

Line 1031: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Update_Row)

1027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030:
1031: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Update_Row)
1032: CSC_PLAN_HEADERS_B_PKG.Update_Row(
1033: p_PLAN_ID => l_upd_plan_headers_b_rec.PLAN_ID,
1034: p_ORIGINAL_PLAN_ID => l_upd_plan_headers_b_rec.ORIGINAL_PLAN_ID,
1035: p_PLAN_GROUP_CODE => l_upd_plan_headers_b_rec.PLAN_GROUP_CODE,

Line 1032: CSC_PLAN_HEADERS_B_PKG.Update_Row(

1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030:
1031: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Update_Row)
1032: CSC_PLAN_HEADERS_B_PKG.Update_Row(
1033: p_PLAN_ID => l_upd_plan_headers_b_rec.PLAN_ID,
1034: p_ORIGINAL_PLAN_ID => l_upd_plan_headers_b_rec.ORIGINAL_PLAN_ID,
1035: p_PLAN_GROUP_CODE => l_upd_plan_headers_b_rec.PLAN_GROUP_CODE,
1036: p_START_DATE_ACTIVE => l_upd_plan_headers_b_rec.START_DATE_ACTIVE,

Line 1229: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Disable_Row)

1225:
1226: -- Initialize API return status to SUCCESS
1227: x_return_status := FND_API.G_RET_STS_SUCCESS;
1228:
1229: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Disable_Row)
1230: CSC_PLAN_HEADERS_B_PKG.Disable_Row(
1231: p_PLAN_ID => p_PLAN_ID);
1232:
1233: -- Change the end_date_active of the CSC_CUST_PLANS table to sysdate+1 for all records

Line 1230: CSC_PLAN_HEADERS_B_PKG.Disable_Row(

1226: -- Initialize API return status to SUCCESS
1227: x_return_status := FND_API.G_RET_STS_SUCCESS;
1228:
1229: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Disable_Row)
1230: CSC_PLAN_HEADERS_B_PKG.Disable_Row(
1231: p_PLAN_ID => p_PLAN_ID);
1232:
1233: -- Change the end_date_active of the CSC_CUST_PLANS table to sysdate+1 for all records
1234: -- with this plan_id. The plan assignment engine will then check all records with