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 2687: l_new_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

Line 5059: -- x_assignment_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

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

Line 5077: , X_ASSIGNMENT_ID_TBL OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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

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

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

Line 5731: -- p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE Required

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

Line 5735: -- x_req_asgn_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

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

Line 5752: , p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

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

Line 5753: , x_req_asgn_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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

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

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

Line 6158: -- x_assignment_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

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

Line 6177: , x_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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

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

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

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

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

Line 10830: -- x_competence_element_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

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

Line 10849: , x_competence_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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

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

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

Line 12483: -- x_candidate_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

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

Line 12502: , x_candidate_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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

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

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

Line 14014: -- x_candidate_review_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE

14010: -- To be compliant with Applications API coding standards.
14011: -- p_candidate_log_tbl IN CANDIDATE_LOG_TBL_TYPE Required
14012: -- Table of candidate review records. Please see the CANDIDATE_LOG_TBL_TYPE datatype table.
14013: -- OUT :
14014: -- x_candidate_review_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
14015: -- Table to store the candidate review ids created by the API.
14016: -- Reference : pa_candidate_reviews.candidate_review_id
14017: -- x_return_status OUT VARCHAR2
14018: -- Indicates the return status of the API.

Line 14033: , x_candidate_review_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

14029: p_commit IN VARCHAR2 := FND_API.G_FALSE
14030: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
14031: , p_api_version_number IN NUMBER := 1.0
14032: , p_candidate_log_tbl IN CANDIDATE_LOG_TBL_TYPE
14033: , x_candidate_review_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
14034: , x_return_status OUT NOCOPY VARCHAR2
14035: , x_msg_count OUT NOCOPY NUMBER
14036: , x_msg_data OUT NOCOPY VARCHAR2
14037: )

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

14102: -------------------------------------------
14103: --1. Validations like status_code change allowed or not are handled by the underlying apis.
14104:
14105: x_return_status := FND_API.G_RET_STS_SUCCESS;
14106: x_candidate_review_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
14107:
14108: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
14109:
14110: IF l_debug_mode = 'Y' THEN