DBA Data[Home] [Help]

APPS.AHL_PRD_WO_LOGIN_PVT dependencies on AHL_PP_RESRC_ASSIGN_PVT

Line 553: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;

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

Line 554: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

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

Line 555: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

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

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

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

Line 764: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (

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

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

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

Line 914: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;

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

Line 915: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

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

Line 916: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

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

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

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

Line 1086: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (

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

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

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

Line 1235: l_resrc_assign_cre_tbl AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type;

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

Line 1236: l_assignment_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

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

Line 1237: l_initial_assign_rec AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Rec_Type;

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

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

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

Line 1377: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (

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

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

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