DBA Data[Home] [Help]

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PA_PROJECT_PUB

Line 36: L_PROJECT_IN_REC pa_project_pub.PROJECT_IN_REC_TYPE ;

32:
33:
34:
35: -- Records
36: L_PROJECT_IN_REC pa_project_pub.PROJECT_IN_REC_TYPE ;
37: L_PROJECT_OUT_REC pa_project_pub.PROJECT_OUT_REC_TYPE;
38:
39:
40:

Line 37: L_PROJECT_OUT_REC pa_project_pub.PROJECT_OUT_REC_TYPE;

33:
34:
35: -- Records
36: L_PROJECT_IN_REC pa_project_pub.PROJECT_IN_REC_TYPE ;
37: L_PROJECT_OUT_REC pa_project_pub.PROJECT_OUT_REC_TYPE;
38:
39:
40:
41:

Line 66: L_TASKS_IN_REC_TBL pa_project_pub.TASK_IN_TBL_TYPE;

62: --L_TASKS_OUT_OBJ TASK_OUT_OBJ;
63: --L_STRUCTURE_IN_OBJ STRUCTURE_IN_OBJ;
64: -- Tables
65:
66: L_TASKS_IN_REC_TBL pa_project_pub.TASK_IN_TBL_TYPE;
67: L_TASKS_OUT_REC_TBL pa_project_pub.TASK_OUT_TBL_TYPE;
68: L_TASK_OUT_REC pa_project_pub.task_out_rec_type;
69: L_STRUCTURE_IN_REC pa_project_pub.STRUCTURE_IN_REC_TYPE;
70:

Line 67: L_TASKS_OUT_REC_TBL pa_project_pub.TASK_OUT_TBL_TYPE;

63: --L_STRUCTURE_IN_OBJ STRUCTURE_IN_OBJ;
64: -- Tables
65:
66: L_TASKS_IN_REC_TBL pa_project_pub.TASK_IN_TBL_TYPE;
67: L_TASKS_OUT_REC_TBL pa_project_pub.TASK_OUT_TBL_TYPE;
68: L_TASK_OUT_REC pa_project_pub.task_out_rec_type;
69: L_STRUCTURE_IN_REC pa_project_pub.STRUCTURE_IN_REC_TYPE;
70:
71:

Line 68: L_TASK_OUT_REC pa_project_pub.task_out_rec_type;

64: -- Tables
65:
66: L_TASKS_IN_REC_TBL pa_project_pub.TASK_IN_TBL_TYPE;
67: L_TASKS_OUT_REC_TBL pa_project_pub.TASK_OUT_TBL_TYPE;
68: L_TASK_OUT_REC pa_project_pub.task_out_rec_type;
69: L_STRUCTURE_IN_REC pa_project_pub.STRUCTURE_IN_REC_TYPE;
70:
71:
72: l_delete_task_id_tbl g_num_tbl;

Line 69: L_STRUCTURE_IN_REC pa_project_pub.STRUCTURE_IN_REC_TYPE;

65:
66: L_TASKS_IN_REC_TBL pa_project_pub.TASK_IN_TBL_TYPE;
67: L_TASKS_OUT_REC_TBL pa_project_pub.TASK_OUT_TBL_TYPE;
68: L_TASK_OUT_REC pa_project_pub.task_out_rec_type;
69: L_STRUCTURE_IN_REC pa_project_pub.STRUCTURE_IN_REC_TYPE;
70:
71:
72: l_delete_task_id_tbl g_num_tbl;
73: l_delete_task_ver_id_tbl g_num_tbl;

Line 352: PA_PROJECT_PUB.CREATE_PROJECT( P_API_VERSION_NUMBER => 1.0,

348: END IF ;
349: -- org_context changes end
350: log_pvt('MAIN','before create_project ');
351:
352: PA_PROJECT_PUB.CREATE_PROJECT( P_API_VERSION_NUMBER => 1.0,
353: P_COMMIT => fnd_api.g_false,
354: P_INIT_MSG_LIST => 'T',
355: P_MSG_COUNT => X_MSG_COUNT,
356: P_MSG_DATA => X_MSG_DATA,

Line 458: PA_PROJECT_PUB.UPDATE_PROJECT( P_API_VERSION_NUMBER => 1.0,

454: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
455: RAISE FND_API.G_EXC_ERROR ;
456: END IF ;
457: -- org_context changes end
458: PA_PROJECT_PUB.UPDATE_PROJECT( P_API_VERSION_NUMBER => 1.0,
459: P_COMMIT => fnd_api.g_false,
460: P_INIT_MSG_LIST => 'T',
461: P_MSG_COUNT => X_MSG_COUNT,
462: P_MSG_DATA => X_MSG_DATA,

Line 1445: x_project_in_rec OUT NOCOPY pa_project_pub.project_in_rec_type,

1441: END SYNC_PROJECTS;
1442:
1443: PROCEDURE LOAD_PROJECT_IN_REC (
1444: P_PROJECT_IN_OBJ IN SYSTEM.PROJECT_IN_OBJ ,
1445: x_project_in_rec OUT NOCOPY pa_project_pub.project_in_rec_type,
1446: x_task_in_tbl OUT NOCOPY pa_project_pub.task_in_tbl_type,
1447: x_structure_in_rec OUT NOCOPY pa_project_pub.structure_in_rec_type,
1448: x_task_com_id_tbl OUT NOCOPY task_com_id_tbl_type,
1449: x_task_id_ref_tbl OUT NOCOPY task_id_ref_tbl_type,

Line 1446: x_task_in_tbl OUT NOCOPY pa_project_pub.task_in_tbl_type,

1442:
1443: PROCEDURE LOAD_PROJECT_IN_REC (
1444: P_PROJECT_IN_OBJ IN SYSTEM.PROJECT_IN_OBJ ,
1445: x_project_in_rec OUT NOCOPY pa_project_pub.project_in_rec_type,
1446: x_task_in_tbl OUT NOCOPY pa_project_pub.task_in_tbl_type,
1447: x_structure_in_rec OUT NOCOPY pa_project_pub.structure_in_rec_type,
1448: x_task_com_id_tbl OUT NOCOPY task_com_id_tbl_type,
1449: x_task_id_ref_tbl OUT NOCOPY task_id_ref_tbl_type,
1450: x_res_com_id_tbl OUT NOCOPY task_com_id_tbl_type ,

Line 1447: x_structure_in_rec OUT NOCOPY pa_project_pub.structure_in_rec_type,

1443: PROCEDURE LOAD_PROJECT_IN_REC (
1444: P_PROJECT_IN_OBJ IN SYSTEM.PROJECT_IN_OBJ ,
1445: x_project_in_rec OUT NOCOPY pa_project_pub.project_in_rec_type,
1446: x_task_in_tbl OUT NOCOPY pa_project_pub.task_in_tbl_type,
1447: x_structure_in_rec OUT NOCOPY pa_project_pub.structure_in_rec_type,
1448: x_task_com_id_tbl OUT NOCOPY task_com_id_tbl_type,
1449: x_task_id_ref_tbl OUT NOCOPY task_id_ref_tbl_type,
1450: x_res_com_id_tbl OUT NOCOPY task_com_id_tbl_type ,
1451: x_res_id_ref_tbl OUT NOCOPY task_id_ref_tbl_type ,

Line 1458: -- RETURN pa_project_pub.PROJECT_IN_REC_TYPE IS

1454: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1455: x_RETURN_MESSAGE OUT NOCOPY VARCHAR2 ) IS
1456:
1457: -- FUNCTION LOAD_PROJECT_IN_REC ( l_PROJECT_IN_OBJ IN PROJECT_IN_OBJ )
1458: -- RETURN pa_project_pub.PROJECT_IN_REC_TYPE IS
1459:
1460: -- Records
1461: L_PROJECT_IN_REC pa_project_pub.PROJECT_IN_REC_TYPE ;
1462: --Objects

Line 1461: L_PROJECT_IN_REC pa_project_pub.PROJECT_IN_REC_TYPE ;

1457: -- FUNCTION LOAD_PROJECT_IN_REC ( l_PROJECT_IN_OBJ IN PROJECT_IN_OBJ )
1458: -- RETURN pa_project_pub.PROJECT_IN_REC_TYPE IS
1459:
1460: -- Records
1461: L_PROJECT_IN_REC pa_project_pub.PROJECT_IN_REC_TYPE ;
1462: --Objects
1463: L_PROJECT_IN_OBJ SYSTEM.PROJECT_IN_OBJ ;
1464:
1465:

Line 1483: L_TASK_IN_REC pa_project_pub.TASK_IN_REC_TYPE;

1479: l_return_message varchar2(200);
1480:
1481: ----- task variables -------------------
1482:
1483: L_TASK_IN_REC pa_project_pub.TASK_IN_REC_TYPE;
1484: L_TASKS_IN_REC_TBL pa_project_pub.TASK_IN_TBL_TYPE;
1485: L_STRUCTURE_IN_OBJ SYSTEM.STRUCTURE_IN_OBJ;
1486: L_TASK_IN_OBJ_TABLE SYSTEM.TASK_IN_OBJ_TBL;
1487: L_TASK_IN_OBJ SYSTEM.TASK_IN_OBJ;

Line 1484: L_TASKS_IN_REC_TBL pa_project_pub.TASK_IN_TBL_TYPE;

1480:
1481: ----- task variables -------------------
1482:
1483: L_TASK_IN_REC pa_project_pub.TASK_IN_REC_TYPE;
1484: L_TASKS_IN_REC_TBL pa_project_pub.TASK_IN_TBL_TYPE;
1485: L_STRUCTURE_IN_OBJ SYSTEM.STRUCTURE_IN_OBJ;
1486: L_TASK_IN_OBJ_TABLE SYSTEM.TASK_IN_OBJ_TBL;
1487: L_TASK_IN_OBJ SYSTEM.TASK_IN_OBJ;
1488: L_COUNTER NUMBER := 1;

Line 1504: L_STRUCTURE_IN_REC pa_project_pub.STRUCTURE_IN_REC_TYPE;

1500: ll_delete_task_ver_id_tbl g_num_tbl;
1501:
1502: ---- Structure variable -----------------------
1503:
1504: L_STRUCTURE_IN_REC pa_project_pub.STRUCTURE_IN_REC_TYPE;
1505: ---L_CREATED_FROM_PROJECT_ID NUMBER;
1506:
1507:
1508: ---- resource assignment variables -----------------------

Line 2322: P_PROJECT_IN_REC IN PA_PROJECT_PUB.PROJECT_IN_REC_TYPE ,

2318:
2319:
2320: PROCEDURE wbs_order (
2321: P_TASK_IN_OBJ_TABLE IN SYSTEM.TASK_IN_OBJ_TBL,
2322: P_PROJECT_IN_REC IN PA_PROJECT_PUB.PROJECT_IN_REC_TYPE ,
2323: P_STRUCTURE_IN_REC IN PA_PROJECT_PUB.STRUCTURE_IN_REC_TYPE,
2324: X_TASK_IN_OBJ_TABLE OUT NOCOPY SYSTEM.TASK_IN_OBJ_TBL,
2325: X_DELETE_TASK_VER_ID_TBL OUT NOCOPY G_NUM_TBL,
2326: X_DELETE_TASK_ID_TBL OUT NOCOPY G_NUM_TBL

Line 2323: P_STRUCTURE_IN_REC IN PA_PROJECT_PUB.STRUCTURE_IN_REC_TYPE,

2319:
2320: PROCEDURE wbs_order (
2321: P_TASK_IN_OBJ_TABLE IN SYSTEM.TASK_IN_OBJ_TBL,
2322: P_PROJECT_IN_REC IN PA_PROJECT_PUB.PROJECT_IN_REC_TYPE ,
2323: P_STRUCTURE_IN_REC IN PA_PROJECT_PUB.STRUCTURE_IN_REC_TYPE,
2324: X_TASK_IN_OBJ_TABLE OUT NOCOPY SYSTEM.TASK_IN_OBJ_TBL,
2325: X_DELETE_TASK_VER_ID_TBL OUT NOCOPY G_NUM_TBL,
2326: X_DELETE_TASK_ID_TBL OUT NOCOPY G_NUM_TBL
2327: ) IS

Line 2496: p_project_in_rec IN pa_project_pub.project_in_rec_type,

2492: END wbs_order;
2493:
2494:
2495: procedure DELETE_RES_ASSGN_PVT (
2496: p_project_in_rec IN pa_project_pub.project_in_rec_type,
2497: p_structure_in_rec IN pa_project_pub.structure_in_rec_type,
2498: p_res_pa_task_assignment_id IN g_num,
2499: x_DEL_RES_ASGMT_OBJ_TBL OUT NOCOPY SYSTEM.delete_RES_ASGMT_OUT_OBJ_TBL,
2500: x_DEL_RES_ASSGMT_STATUS OUT NOCOPY varchar2,

Line 2497: p_structure_in_rec IN pa_project_pub.structure_in_rec_type,

2493:
2494:
2495: procedure DELETE_RES_ASSGN_PVT (
2496: p_project_in_rec IN pa_project_pub.project_in_rec_type,
2497: p_structure_in_rec IN pa_project_pub.structure_in_rec_type,
2498: p_res_pa_task_assignment_id IN g_num,
2499: x_DEL_RES_ASGMT_OBJ_TBL OUT NOCOPY SYSTEM.delete_RES_ASGMT_OUT_OBJ_TBL,
2500: x_DEL_RES_ASSGMT_STATUS OUT NOCOPY varchar2,
2501: x_del_res_msg_data OUT NOCOPY varchar2

Line 2680: p_project_in_rec IN pa_project_pub.project_in_rec_type,

2676: End DELETE_RES_ASSGN_PVT ;
2677:
2678:
2679: procedure DELETE_TASK_PVT(
2680: p_project_in_rec IN pa_project_pub.project_in_rec_type,
2681: p_structure_in_rec IN pa_project_pub.structure_in_rec_type,
2682: p_delete_task_ver_id_tbl IN G_NUM_TBL,
2683: p_delete_task_id_tbl IN G_NUM_TBL,
2684: x_del_task_out_obj_tbl OUT NOCOPY SYSTEM.delete_TASK_OUT_obj_TBL,

Line 2681: p_structure_in_rec IN pa_project_pub.structure_in_rec_type,

2677:
2678:
2679: procedure DELETE_TASK_PVT(
2680: p_project_in_rec IN pa_project_pub.project_in_rec_type,
2681: p_structure_in_rec IN pa_project_pub.structure_in_rec_type,
2682: p_delete_task_ver_id_tbl IN G_NUM_TBL,
2683: p_delete_task_id_tbl IN G_NUM_TBL,
2684: x_del_task_out_obj_tbl OUT NOCOPY SYSTEM.delete_TASK_OUT_obj_TBL,
2685: x_del_task_status OUT NOCOPY varchar2,

Line 2726: pa_project_pub.delete_task ( p_api_version_number => 1.0 -- for bug# 3802319

2722:
2723: begin
2724:
2725:
2726: pa_project_pub.delete_task ( p_api_version_number => 1.0 -- for bug# 3802319
2727: ,p_commit => fnd_api.g_false
2728: ,p_init_msg_list => 'T'
2729: ,p_msg_count => x_msg_count
2730: ,p_msg_data => x_msg_data