eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_NUM_TBL_TYPE

Line 339: -- x_requirement_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

335: -- Valid values are: FND_API.G_FALSE for FALSE and FND_API.G_TRUE for TRUE
336: -- p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE Required
337: -- Table of requirement records. Please see the REQUIREMENT_IN_TBL_TYPE datatype table.
338: -- OUT :
339: -- x_requirement_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
340: -- Table to store requirement_ids created by the API.
341: -- Reference: pa_project_assignments.assignment_id
342: -- x_return_status OUT VARCHAR2
343: -- Indicates the return status of the API.

Line 358: , x_requirement_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

354: p_api_version_number IN NUMBER := 1.0
355: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
356: , p_commit IN VARCHAR2 := FND_API.G_FALSE
357: , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
358: , x_requirement_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
359: , x_return_status OUT NOCOPY VARCHAR2
360: , x_msg_count OUT NOCOPY NUMBER
361: , x_msg_data OUT NOCOPY VARCHAR2
362: )

Line 381: l_new_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

377: l_data VARCHAR2(2000);
378: l_debug_mode VARCHAR2(1);
379:
380: i NUMBER;
381: l_new_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
382: l_new_assignment_id NUMBER;
383: l_assignment_number NUMBER;
384: l_assignment_row_id ROWID;
385: l_resource_id NUMBER;

Line 577: x_requirement_id_tbl:= SYSTEM.pa_num_tbl_type();

573: --4. Either status_code or status_name should be specified.
574:
575:
576: x_return_status := FND_API.G_RET_STS_SUCCESS;
577: x_requirement_id_tbl:= SYSTEM.pa_num_tbl_type();
578:
579: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
580:
581: IF l_debug_mode = 'Y' THEN

Line 2688: l_new_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2684: l_data VARCHAR2(2000);
2685: l_debug_mode VARCHAR2(1);
2686:
2687: i NUMBER;
2688: l_new_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2689: l_new_assignment_id NUMBER;
2690: l_assignment_number NUMBER;
2691: l_assignment_row_id ROWID;
2692: l_resource_id NUMBER;

Line 5060: -- x_assignment_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

5056: -- To be compliant with Applications API coding standards.
5057: -- p_staff_requirement_tbl IN STAFF_REQUIREMENT_TBL_TYPE Required
5058: -- Table of staffing information for each requirement. Please see the datatype Staff_requirement_tbl_TYPE.
5059: -- OUT :
5060: -- x_assignment_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
5061: -- Table to store the staffed assignment ids and newly created requirement_ids
5062: -- x_return_status OUT VARCHAR2
5063: -- Indicates the return status of the API.
5064: -- Valid values are: 'S' for Success, 'E' for Error, 'U' for Unexpected Error

Line 5078: , X_ASSIGNMENT_ID_TBL OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

5074: p_api_version_number IN NUMBER := 1.0
5075: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5076: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5077: , P_STAFF_REQUIREMENT_TBL IN STAFF_REQUIREMENT_TBL_TYPE
5078: , X_ASSIGNMENT_ID_TBL OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
5079: , x_return_status OUT NOCOPY VARCHAR2
5080: , x_msg_count OUT NOCOPY NUMBER
5081: , x_msg_data OUT NOCOPY VARCHAR2
5082: )

Line 5194: X_ASSIGNMENT_ID_TBL := SYSTEM.PA_NUM_TBL_TYPE();

5190: x_return_status := FND_API.G_RET_STS_SUCCESS;
5191: x_msg_count := 0;
5192: x_msg_data := NULL ;
5193:
5194: X_ASSIGNMENT_ID_TBL := SYSTEM.PA_NUM_TBL_TYPE();
5195: --------------------------------------------------
5196: -- Initialize Current Function and Msg Stack
5197: --------------------------------------------------
5198: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

Line 5732: -- p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE Required

5728: -- Identifier to initialize the error message stack.
5729: -- Valid values are: FND_API.G_FALSE for FALSE amd FND_API.G_TRUE for TRUE
5730: -- p_api_version_number IN NUMBER Required
5731: -- To be compliant with Applications API coding standards.
5732: -- p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE Required
5733: -- Table of requirement or assignment ids.
5734: -- Reference: pa_project_assignments.assignment_id
5735: -- OUT :
5736: -- x_req_asgn_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

Line 5736: -- x_req_asgn_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

5732: -- p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE Required
5733: -- Table of requirement or assignment ids.
5734: -- Reference: pa_project_assignments.assignment_id
5735: -- OUT :
5736: -- x_req_asgn_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
5737: -- Table to store the created requirement or assignment ids
5738: -- x_return_status OUT VARCHAR2
5739: -- Indicates the return status of the API.
5740: -- Valid values are: 'S' for Success, 'E' for Error, 'U' for Unexpected Error

Line 5753: , p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

5749: (
5750: p_api_version_number IN NUMBER := 1.0
5751: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5752: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5753: , p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5754: , x_req_asgn_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
5755: , x_return_status OUT NOCOPY VARCHAR2
5756: , x_msg_count OUT NOCOPY NUMBER
5757: , x_msg_data OUT NOCOPY VARCHAR2

Line 5754: , x_req_asgn_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

5750: p_api_version_number IN NUMBER := 1.0
5751: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5752: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5753: , p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5754: , x_req_asgn_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
5755: , x_return_status OUT NOCOPY VARCHAR2
5756: , x_msg_count OUT NOCOPY NUMBER
5757: , x_msg_data OUT NOCOPY VARCHAR2
5758: )

Line 5832: X_REQ_ASGN_ID_TBL := SYSTEM.PA_NUM_TBL_TYPE();

5828: x_return_status := FND_API.G_RET_STS_SUCCESS;
5829: x_msg_count := 0;
5830: x_msg_data := NULL ;
5831:
5832: X_REQ_ASGN_ID_TBL := SYSTEM.PA_NUM_TBL_TYPE();
5833: --------------------------------------------------
5834: -- Initialize Current Function and Msg Stack
5835: --------------------------------------------------
5836: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

Line 6159: -- x_assignment_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

6155: -- p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE Required
6156: -- Table of assignment records.
6157: -- Please see the ASSIGNMENT_IN_TBL_TYPE datatype table.
6158: -- OUT :
6159: -- x_assignment_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
6160: -- Table to store assignment ids created by the API.
6161: -- Reference: pa_project_assignments.assignment_id
6162: -- x_return_status OUT VARCHAR2
6163: -- Indicates the return status of the API.

Line 6178: , x_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

6174: p_api_version_number IN NUMBER := 1.0
6175: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6176: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6177: , p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE
6178: , x_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
6179: , x_return_status OUT NOCOPY VARCHAR2
6180: , x_msg_count OUT NOCOPY NUMBER
6181: , x_msg_data OUT NOCOPY VARCHAR2
6182: )

Line 6201: l_new_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

6197: l_data VARCHAR2(2000);
6198: l_debug_mode VARCHAR2(1);
6199:
6200: i NUMBER;
6201: l_new_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6202: l_new_assignment_id NUMBER;
6203: l_assignment_number NUMBER;
6204: l_assignment_row_id ROWID;
6205: l_resource_id NUMBER;

Line 6387: x_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();

6383: --6. Either status_code or status_name should be specified.
6384:
6385:
6386: x_return_status := FND_API.G_RET_STS_SUCCESS;
6387: x_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();
6388:
6389: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
6390:
6391: IF l_debug_mode = 'Y' THEN

Line 10832: -- x_competence_element_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

10828: -- p_competence_in_tbl IN COMPETENCE_IN_TBL Required
10829: -- Table of competence records.
10830: -- Please see the COMPETENCE_IN_TBL_TYPE datatype table.
10831: -- OUT :
10832: -- x_competence_element_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
10833: -- Table to store the competence element ids created by the API.
10834: -- Reference: per_comepetence_elements.competence_element_id
10835: -- x_return_status OUT VARCHAR2
10836: -- Indicates the return status of the API.

Line 10851: , x_competence_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

10847: p_commit IN VARCHAR2 :='F'
10848: , p_init_msg_list IN VARCHAR2 :='T'
10849: , p_api_version_number IN NUMBER :=1.0
10850: , p_competence_in_tbl IN COMPETENCE_IN_TBL_TYPE
10851: , x_competence_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
10852: , x_return_status OUT NOCOPY VARCHAR2
10853: , x_msg_count OUT NOCOPY NUMBER
10854: , x_msg_data OUT NOCOPY VARCHAR2
10855: )

Line 10927: x_competence_element_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

10923: -- Mandatary Flag and Rating level.
10924:
10925: x_return_status := FND_API.G_RET_STS_SUCCESS;
10926:
10927: x_competence_element_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
10928:
10929: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
10930:
10931:

Line 12485: -- x_candidate_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

12481: -- To be compliant with Applications API coding standards.
12482: -- p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE Required
12483: -- Table of candidate records. Please see the CANDIDATE_IN_TBL_TYPE datatype table.
12484: -- OUT :
12485: -- x_candidate_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
12486: -- Table to store the candidate ids created by the API.
12487: -- Reference : pa_candidates.candidate_id
12488: -- x_return_status OUT VARCHAR2
12489: -- Indicates the return status of the API.

Line 12504: , x_candidate_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

12500: p_commit IN VARCHAR2 := FND_API.G_FALSE
12501: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
12502: , p_api_version_number IN NUMBER := 1.0
12503: , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
12504: , x_candidate_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
12505: , x_return_status OUT NOCOPY VARCHAR2
12506: , x_msg_count OUT NOCOPY NUMBER
12507: , x_msg_data OUT NOCOPY VARCHAR2
12508: )

Line 12596: x_candidate_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

12592: -------------------------------------------
12593: --1. Validating person_id is not done in this api. It is handled by the called public api.
12594:
12595: x_return_status := FND_API.G_RET_STS_SUCCESS;
12596: x_candidate_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
12597:
12598: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
12599:
12600: IF l_debug_mode = 'Y' THEN

Line 14052: -- x_candidate_review_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

14048: -- To be compliant with Applications API coding standards.
14049: -- p_candidate_log_tbl IN CANDIDATE_LOG_TBL_TYPE Required
14050: -- Table of candidate review records. Please see the CANDIDATE_LOG_TBL_TYPE datatype table.
14051: -- OUT :
14052: -- x_candidate_review_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
14053: -- Table to store the candidate review ids created by the API.
14054: -- Reference : pa_candidate_reviews.candidate_review_id
14055: -- x_return_status OUT VARCHAR2
14056: -- Indicates the return status of the API.

Line 14071: , x_candidate_review_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

14067: p_commit IN VARCHAR2 := FND_API.G_FALSE
14068: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
14069: , p_api_version_number IN NUMBER := 1.0
14070: , p_candidate_log_tbl IN CANDIDATE_LOG_TBL_TYPE
14071: , x_candidate_review_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
14072: , x_return_status OUT NOCOPY VARCHAR2
14073: , x_msg_count OUT NOCOPY NUMBER
14074: , x_msg_data OUT NOCOPY VARCHAR2
14075: )

Line 14144: x_candidate_review_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

14140: -------------------------------------------
14141: --1. Validations like status_code change allowed or not are handled by the underlying apis.
14142:
14143: x_return_status := FND_API.G_RET_STS_SUCCESS;
14144: x_candidate_review_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
14145:
14146: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
14147:
14148: IF l_debug_mode = 'Y' THEN