387:
388: G_PM_PRODUCT_CODE VARCHAR2(30) := 'AMW';
389:
390: -- Define local table and record datatypes
391: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
392: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
393:
394: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
395: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
388: G_PM_PRODUCT_CODE VARCHAR2(30) := 'AMW';
389:
390: -- Define local table and record datatypes
391: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
392: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
393:
394: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
395: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
396: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
390: -- Define local table and record datatypes
391: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
392: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
393:
394: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
395: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
396: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
397: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
398:
391: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
392: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
393:
394: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
395: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
396: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
397: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
398:
399: l_data VARCHAR2(2000);
392: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
393:
394: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
395: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
396: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
397: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
398:
399: l_data VARCHAR2(2000);
400: l_msg_index_out NUMBER;
393:
394: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
395: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
396: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
397: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
398:
399: l_data VARCHAR2(2000);
400: l_msg_index_out NUMBER;
401:
460:
461:
462: FND_MSG_PUB.initialize;
463:
464: PA_PROJECT_PUB.CREATE_PROJECT
465: (p_api_version_number => 1,
466: p_commit => l_commit,
467: p_init_msg_list => l_init_msg_list,
468: p_msg_count => l_msg_count,
526: l_workflow_started VARCHAR2(1);
527:
528:
529: -- Define local table and record datatypes
530: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
531: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
532:
533: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
534: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
527:
528:
529: -- Define local table and record datatypes
530: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
531: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
532:
533: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
534: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
535: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
529: -- Define local table and record datatypes
530: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
531: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
532:
533: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
534: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
535: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
536: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
537:
530: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
531: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
532:
533: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
534: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
535: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
536: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
537:
538: l_data VARCHAR2(2000);
531: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
532:
533: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
534: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
535: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
536: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
537:
538: l_data VARCHAR2(2000);
539: l_msg_index_out NUMBER;
532:
533: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
534: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
535: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
536: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
537:
538: l_data VARCHAR2(2000);
539: l_msg_index_out NUMBER;
540:
582:
583:
584: FND_MSG_PUB.initialize;
585:
586: PA_PROJECT_PUB.UPDATE_PROJECT
587: (p_api_version_number => 1,
588: p_commit => l_commit,
589: p_init_msg_list => l_init_msg_list,
590: p_msg_count => l_msg_count,
685: where project_id = p_project_id;
686:
687: FND_MSG_PUB.initialize;
688:
689: PA_PROJECT_PUB.ADD_TASK(
690: p_api_version_number => 1
691: ,p_commit => l_commit
692: ,p_init_msg_list => l_init_msg_list
693: ,p_msg_count => l_msg_count
775: where project_id = p_project_id;
776:
777: FND_MSG_PUB.initialize;
778:
779: PA_PROJECT_PUB.UPDATE_TASK(
780: p_api_version_number => 1
781: ,p_commit => l_commit
782: ,p_init_msg_list => l_init_msg_list
783: ,p_msg_count => l_msg_count
865: and project_id = p_project_id;
866:
867: FND_MSG_PUB.initialize;
868:
869: PA_PROJECT_PUB.DELETE_TASK(
870: p_api_version_number => 1
871: ,p_commit => l_commit
872: ,p_init_msg_list => l_init_msg_list
873: ,p_msg_count => l_msg_count