DBA Data[Home] [Help]

APPS.AHL_PRD_WO_LOGIN_PVT dependencies on AHL_PP_RESRC_ASSIGN_PVT

Line 550: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;

546: WHERE AWAS.operation_resource_id = p_operation_resource_id
547: AND AWAS.employee_id = p_employee_id;
548:
549: -- parameters to call Assignment API.
550: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;
551: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
552: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
553:
554: l_object_ver_num NUMBER;

Line 551: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

547: AND AWAS.employee_id = p_employee_id;
548:
549: -- parameters to call Assignment API.
550: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;
551: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
552: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
553:
554: l_object_ver_num NUMBER;
555: l_assignment_id NUMBER;

Line 552: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

548:
549: -- parameters to call Assignment API.
550: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;
551: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
552: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
553:
554: l_object_ver_num NUMBER;
555: l_assignment_id NUMBER;
556:

Line 758: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);

754: IF (l_resrc_assign_cre_tbl.COUNT > 0) THEN
755:
756: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
757: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
758: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);
759: END IF;
760:
761: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (
762: p_api_version => 1.0,

Line 761: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (

757: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
758: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);
759: END IF;
760:
761: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (
762: p_api_version => 1.0,
763: p_commit => Fnd_Api.G_FALSE,
764: p_operation_flag => 'C',
765: p_x_resrc_assign_tbl => l_resrc_assign_cre_tbl,

Line 774: 'After calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:x_return_status:' || x_return_status);

770:
771:
772: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
773: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
774: 'After calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:x_return_status:' || x_return_status);
775: END IF;
776:
777: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 911: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;

907: AND AWAS.employee_id = p_employee_id;
908:
909:
910: -- parameters to call Assignment API.
911: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;
912: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
913: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
914:
915: l_object_ver_num NUMBER;

Line 912: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

908:
909:
910: -- parameters to call Assignment API.
911: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;
912: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
913: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
914:
915: l_object_ver_num NUMBER;
916: l_assignment_id NUMBER;

Line 913: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

909:
910: -- parameters to call Assignment API.
911: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;
912: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
913: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
914:
915: l_object_ver_num NUMBER;
916: l_assignment_id NUMBER;
917:

Line 1080: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);

1076: IF (l_resrc_assign_cre_tbl.COUNT > 0) THEN
1077:
1078: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1079: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1080: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);
1081: END IF;
1082:
1083: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (
1084: p_api_version => 1.0,

Line 1083: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (

1079: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1080: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);
1081: END IF;
1082:
1083: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (
1084: p_api_version => 1.0,
1085: p_commit => Fnd_Api.G_FALSE,
1086: p_operation_flag => 'C',
1087: p_x_resrc_assign_tbl => l_resrc_assign_cre_tbl,

Line 1096: 'After calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:x_return_status:' || x_return_status);

1092:
1093:
1094: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1095: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1096: 'After calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:x_return_status:' || x_return_status);
1097: END IF;
1098:
1099: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1232: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;

1228: AND AWAS.employee_id = p_employee_id;
1229:
1230:
1231: -- parameters to call Assignment API.
1232: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;
1233: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
1234: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
1235:
1236: l_object_ver_num NUMBER;

Line 1233: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

1229:
1230:
1231: -- parameters to call Assignment API.
1232: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;
1233: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
1234: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
1235:
1236: l_object_ver_num NUMBER;
1237: l_assignment_id NUMBER;

Line 1234: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

1230:
1231: -- parameters to call Assignment API.
1232: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;
1233: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
1234: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;
1235:
1236: l_object_ver_num NUMBER;
1237: l_assignment_id NUMBER;
1238:

Line 1371: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);

1367: IF (l_resrc_assign_cre_tbl.COUNT > 0) THEN
1368:
1369: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1370: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1371: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);
1372: END IF;
1373:
1374: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (
1375: p_api_version => 1.0,

Line 1374: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (

1370: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1371: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);
1372: END IF;
1373:
1374: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (
1375: p_api_version => 1.0,
1376: p_commit => Fnd_Api.G_FALSE,
1377: p_operation_flag => 'C',
1378: p_x_resrc_assign_tbl => l_resrc_assign_cre_tbl,

Line 1387: 'After calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:x_return_status:' || x_return_status);

1383:
1384:
1385: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1386: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1387: 'After calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:x_return_status:' || x_return_status);
1388: END IF;
1389:
1390: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;