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.

[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 4: G_PA_MISS_NUM CONSTANT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

1: PACKAGE BODY PA_RES_MANAGEMENT_AMG_PUB AS
2: /* $Header: PAPMRSPB.pls 120.14.12020000.2 2012/07/19 09:56:24 admarath ship $ */
3:
4: G_PA_MISS_NUM CONSTANT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
5: G_PA_MISS_DATE CONSTANT DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
6: G_PA_MISS_CHAR CONSTANT VARCHAR2(3) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
7:
8: /*---Bug 6511907 PJR Date Validation Enhancement ----- Start---*/

Line 5: G_PA_MISS_DATE CONSTANT DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

1: PACKAGE BODY PA_RES_MANAGEMENT_AMG_PUB AS
2: /* $Header: PAPMRSPB.pls 120.14.12020000.2 2012/07/19 09:56:24 admarath ship $ */
3:
4: G_PA_MISS_NUM CONSTANT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
5: G_PA_MISS_DATE CONSTANT DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
6: G_PA_MISS_CHAR CONSTANT VARCHAR2(3) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
7:
8: /*---Bug 6511907 PJR Date Validation Enhancement ----- Start---*/
9:

Line 6: G_PA_MISS_CHAR CONSTANT VARCHAR2(3) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

2: /* $Header: PAPMRSPB.pls 120.14.12020000.2 2012/07/19 09:56:24 admarath ship $ */
3:
4: G_PA_MISS_NUM CONSTANT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
5: G_PA_MISS_DATE CONSTANT DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
6: G_PA_MISS_CHAR CONSTANT VARCHAR2(3) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
7:
8: /*---Bug 6511907 PJR Date Validation Enhancement ----- Start---*/
9:
10: FUNCTION GET_PROJECT_START_DATE(l_prj_id NUMBER)

Line 185: p_desc_flex_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

181: -- History :
182: -- 01-Mar-2006 - amksingh - Created
183: -- End of comments
184: PROCEDURE VALIDATE_FLEX_FIELD(
185: p_desc_flex_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
186: , p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
187: , px_attribute1 IN OUT NOCOPY VARCHAR2
188: , px_attribute2 IN OUT NOCOPY VARCHAR2
189: , px_attribute3 IN OUT NOCOPY VARCHAR2

Line 186: , p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

182: -- 01-Mar-2006 - amksingh - Created
183: -- End of comments
184: PROCEDURE VALIDATE_FLEX_FIELD(
185: p_desc_flex_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
186: , p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
187: , px_attribute1 IN OUT NOCOPY VARCHAR2
188: , px_attribute2 IN OUT NOCOPY VARCHAR2
189: , px_attribute3 IN OUT NOCOPY VARCHAR2
190: , px_attribute4 IN OUT NOCOPY VARCHAR2

Line 2592: PA_INTERFACE_UTILS_PUB.get_messages

2588: ROLLBACK TO CREATE_REQUIREMENTS_SP;
2589: END IF;
2590:
2591: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
2592: PA_INTERFACE_UTILS_PUB.get_messages
2593: ( p_encoded => FND_API.G_FALSE
2594: , p_msg_index => 1
2595: , p_msg_count => l_msg_count
2596: , p_msg_data => l_msg_data

Line 4601: PA_INTERFACE_UTILS_PUB.get_messages

4597: ROLLBACK TO UPDATE_REQUIREMENTS_SP;
4598: END IF;
4599:
4600: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
4601: PA_INTERFACE_UTILS_PUB.get_messages
4602: ( p_encoded => FND_API.G_FALSE
4603: , p_msg_index => 1
4604: , p_msg_count => l_msg_count
4605: , p_msg_data => l_msg_data

Line 4803: IF l_req_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4799:
4800: l_req_rec := p_requirement_in_tbl(i);
4801:
4802: -- Blank Out Parameters if not passed.
4803: IF l_req_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4804: l_req_rec.requirement_id := NULL ;
4805: END IF;
4806:
4807: IF l_req_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 4807: IF l_req_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4803: IF l_req_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4804: l_req_rec.requirement_id := NULL ;
4805: END IF;
4806:
4807: IF l_req_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4808: l_req_rec.record_version_number := NULL ;
4809: END IF;
4810:
4811: IF l_debug_mode = 'Y' THEN

Line 4994: PA_INTERFACE_UTILS_PUB.get_messages

4990: CLOSE c_get_system_status ;
4991: END IF;
4992:
4993: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
4994: PA_INTERFACE_UTILS_PUB.get_messages
4995: ( p_encoded => FND_API.G_FALSE
4996: , p_msg_index => 1
4997: , p_msg_count => l_msg_count
4998: , p_msg_data => l_msg_data

Line 5254: IF l_staff_rec.source_requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

5250: -- Commented out as this param needs to be derived inside code
5251: -- it should not be exposed to the user
5252:
5253:
5254: IF l_staff_rec.source_requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5255: l_staff_rec.source_requirement_id := NULL ;
5256: END IF;
5257:
5258: IF l_staff_rec.resource_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 5258: IF l_staff_rec.resource_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

5254: IF l_staff_rec.source_requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5255: l_staff_rec.source_requirement_id := NULL ;
5256: END IF;
5257:
5258: IF l_staff_rec.resource_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5259: l_staff_rec.resource_id := NULL ;
5260: END IF;
5261:
5262: IF l_staff_rec.person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 5262: IF l_staff_rec.person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

5258: IF l_staff_rec.resource_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5259: l_staff_rec.resource_id := NULL ;
5260: END IF;
5261:
5262: IF l_staff_rec.person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5263: l_staff_rec.person_id := NULL ;
5264: END IF;
5265:
5266: IF l_staff_rec.assignment_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 5266: IF l_staff_rec.assignment_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

5262: IF l_staff_rec.person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5263: l_staff_rec.person_id := NULL ;
5264: END IF;
5265:
5266: IF l_staff_rec.assignment_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5267: l_staff_rec.assignment_status_code := NULL ;
5268: END IF;
5269:
5270: IF l_staff_rec.assignment_status_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 5270: IF l_staff_rec.assignment_status_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

5266: IF l_staff_rec.assignment_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5267: l_staff_rec.assignment_status_code := NULL ;
5268: END IF;
5269:
5270: IF l_staff_rec.assignment_status_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5271: l_staff_rec.assignment_status_name := NULL ;
5272: END IF;
5273:
5274: IF l_staff_rec.unfilled_assign_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 5274: IF l_staff_rec.unfilled_assign_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

5270: IF l_staff_rec.assignment_status_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5271: l_staff_rec.assignment_status_name := NULL ;
5272: END IF;
5273:
5274: IF l_staff_rec.unfilled_assign_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5275: l_staff_rec.unfilled_assign_status_code := NULL ;
5276: END IF;
5277:
5278: IF l_staff_rec.unfilled_assign_status_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 5278: IF l_staff_rec.unfilled_assign_status_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

5274: IF l_staff_rec.unfilled_assign_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5275: l_staff_rec.unfilled_assign_status_code := NULL ;
5276: END IF;
5277:
5278: IF l_staff_rec.unfilled_assign_status_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5279: l_staff_rec.unfilled_assign_status_name := NULL ;
5280: END IF;
5281:
5282: IF l_staff_rec.remaining_candidate_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 5282: IF l_staff_rec.remaining_candidate_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

5278: IF l_staff_rec.unfilled_assign_status_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5279: l_staff_rec.unfilled_assign_status_name := NULL ;
5280: END IF;
5281:
5282: IF l_staff_rec.remaining_candidate_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5283: l_staff_rec.remaining_candidate_code := NULL ;
5284: END IF;
5285:
5286: IF l_staff_rec.change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 5286: IF l_staff_rec.change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

5282: IF l_staff_rec.remaining_candidate_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5283: l_staff_rec.remaining_candidate_code := NULL ;
5284: END IF;
5285:
5286: IF l_staff_rec.change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5287: l_staff_rec.change_reason_code := NULL ;
5288: END IF;
5289:
5290: IF l_staff_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 5290: IF l_staff_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

5286: IF l_staff_rec.change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5287: l_staff_rec.change_reason_code := NULL ;
5288: END IF;
5289:
5290: IF l_staff_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5291: l_staff_rec.record_version_number := NULL ;
5292: END IF;
5293:
5294: IF l_staff_rec.start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

Line 5294: IF l_staff_rec.start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

5290: IF l_staff_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5291: l_staff_rec.record_version_number := NULL ;
5292: END IF;
5293:
5294: IF l_staff_rec.start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
5295: l_staff_rec.start_date := NULL ;
5296: END IF;
5297:
5298: IF l_staff_rec.end_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

Line 5298: IF l_staff_rec.end_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

5294: IF l_staff_rec.start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
5295: l_staff_rec.start_date := NULL ;
5296: END IF;
5297:
5298: IF l_staff_rec.end_Date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
5299: l_staff_rec.end_Date := NULL ;
5300: END IF;
5301:
5302: IF l_debug_mode = 'Y' THEN

Line 5656: PA_INTERFACE_UTILS_PUB.get_messages

5652: CLOSE c_valid_unfilled_status_name ;
5653: END IF;
5654:
5655: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
5656: PA_INTERFACE_UTILS_PUB.get_messages
5657: ( p_encoded => FND_API.G_FALSE
5658: , p_msg_index => 1
5659: , p_msg_count => l_msg_count
5660: , p_msg_data => l_msg_data

Line 5889: IF l_req_asgn_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

5885:
5886: l_req_asgn_id := l_req_rec;
5887:
5888: -- Blank Out Parameters if not passed.
5889: IF l_req_asgn_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5890: l_req_asgn_id := NULL ;
5891: END IF ;
5892:
5893: -- Mandatory Parameters Check

Line 6090: PA_INTERFACE_UTILS_PUB.get_messages

6086: CLOSE c_get_system_status ;
6087: END IF;
6088:
6089: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
6090: PA_INTERFACE_UTILS_PUB.get_messages
6091: ( p_encoded => FND_API.G_FALSE
6092: , p_msg_index => 1
6093: , p_msg_count => l_msg_count
6094: , p_msg_data => l_msg_data

Line 7882: PA_INTERFACE_UTILS_PUB.get_messages

7878: ROLLBACK TO CREATE_ASSIGNMENTS_SP;
7879: END IF;
7880:
7881: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
7882: PA_INTERFACE_UTILS_PUB.get_messages
7883: ( p_encoded => FND_API.G_FALSE
7884: , p_msg_index => 1
7885: , p_msg_count => l_msg_count
7886: , p_msg_data => l_msg_data

Line 8255: l_asgn_rec.assignment_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8251: -- Update Project Assignment Flow
8252:
8253: -- Bug 5174557 : Assignment Type Change is not allowed.
8254: IF l_asgn_rec.assignment_type IS NOT NULL AND
8255: l_asgn_rec.assignment_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8256:
8257: IF l_asgn_rec.assignment_type <> l_asgn_db_values_rec.assignment_type THEN
8258: l_missing_params := l_missing_params||', ASSIGNMENT_TYPE';
8259: END IF;

Line 8503: IF l_asgn_rec.assignment_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8499: IF l_debug_mode = 'Y' THEN
8500: pa_debug.write(l_module, 'Take values from database for those parameters which are not passed.', l_log_level);
8501: END IF;
8502:
8503: IF l_asgn_rec.assignment_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8504: l_asgn_rec.assignment_name := l_asgn_db_values_rec.assignment_name ;
8505: END IF;
8506:
8507: IF l_asgn_rec.assignment_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8507: IF l_asgn_rec.assignment_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8503: IF l_asgn_rec.assignment_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8504: l_asgn_rec.assignment_name := l_asgn_db_values_rec.assignment_name ;
8505: END IF;
8506:
8507: IF l_asgn_rec.assignment_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8508: l_asgn_rec.assignment_type := l_asgn_db_values_rec.assignment_type ;
8509: END IF;
8510:
8511: -- These parameters are Not used for Update Flow:

Line 8521: l_asgn_rec.project_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

8517: l_asgn_rec.project_role_name := FND_API.G_MISS_CHAR;
8518:
8519: l_asgn_rec.project_id := l_asgn_db_values_rec.project_id;
8520:
8521: l_asgn_rec.project_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
8522:
8523: l_asgn_rec.project_number := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
8524:
8525: -- Resource ID cant be changed once an assignment is done

Line 8523: l_asgn_rec.project_number := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

8519: l_asgn_rec.project_id := l_asgn_db_values_rec.project_id;
8520:
8521: l_asgn_rec.project_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
8522:
8523: l_asgn_rec.project_number := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
8524:
8525: -- Resource ID cant be changed once an assignment is done
8526: -- Internal API expects it to be passed as Miss NUM
8527: l_asgn_rec.resource_id := FND_API.G_MISS_NUM ;

Line 8530: IF l_asgn_rec.staffing_owner_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

8526: -- Internal API expects it to be passed as Miss NUM
8527: l_asgn_rec.resource_id := FND_API.G_MISS_NUM ;
8528:
8529:
8530: IF l_asgn_rec.staffing_owner_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8531: l_asgn_rec.staffing_owner_person_id := l_asgn_db_values_rec.staffing_owner_person_id ;
8532: END IF;
8533:
8534: IF l_asgn_rec.staffing_priority_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8534: IF l_asgn_rec.staffing_priority_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8530: IF l_asgn_rec.staffing_owner_person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8531: l_asgn_rec.staffing_owner_person_id := l_asgn_db_values_rec.staffing_owner_person_id ;
8532: END IF;
8533:
8534: IF l_asgn_rec.staffing_priority_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8535: l_asgn_rec.staffing_priority_code := l_asgn_db_values_rec.staffing_priority_code ;
8536: END IF;
8537:
8538: IF l_asgn_rec.staffing_priority_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8538: IF l_asgn_rec.staffing_priority_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8534: IF l_asgn_rec.staffing_priority_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8535: l_asgn_rec.staffing_priority_code := l_asgn_db_values_rec.staffing_priority_code ;
8536: END IF;
8537:
8538: IF l_asgn_rec.staffing_priority_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8539: l_asgn_rec.staffing_priority_name := NULL ;
8540: END IF;
8541:
8542: l_project_subteam_party_id := null;

Line 8595: IF l_asgn_rec.description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8591: l_asgn_rec.location_city := null;
8592: END IF;
8593: */
8594:
8595: IF l_asgn_rec.description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8596: l_asgn_rec.description := l_asgn_db_values_rec.description ;
8597: ELSE
8598: l_asgn_rec.description := SUBSTRB(l_asgn_rec.description,1,2000);
8599: END IF;

Line 8601: IF l_asgn_rec.additional_information = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8597: ELSE
8598: l_asgn_rec.description := SUBSTRB(l_asgn_rec.description,1,2000);
8599: END IF;
8600:
8601: IF l_asgn_rec.additional_information = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8602: l_asgn_rec.additional_information := l_asgn_db_values_rec.additional_information ;
8603: ELSE
8604: l_asgn_rec.additional_information := SUBSTRB(l_asgn_rec.additional_information,1,2000) ;
8605: END IF;

Line 8622: IF l_asgn_rec.resource_calendar_percent = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

8618: l_asgn_rec.calendar_id := l_asgn_db_values_rec.calendar_id;
8619:
8620: l_asgn_rec.calendar_name := NULL ;
8621:
8622: IF l_asgn_rec.resource_calendar_percent = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8623: l_asgn_rec.resource_calendar_percent := l_asgn_db_values_rec.resource_calendar_percent ;
8624: END IF;
8625:
8626: IF l_asgn_rec.expenditure_type_class = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8626: IF l_asgn_rec.expenditure_type_class = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8622: IF l_asgn_rec.resource_calendar_percent = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8623: l_asgn_rec.resource_calendar_percent := l_asgn_db_values_rec.resource_calendar_percent ;
8624: END IF;
8625:
8626: IF l_asgn_rec.expenditure_type_class = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8627: l_asgn_rec.expenditure_type_class := l_asgn_db_values_rec.expenditure_type_class ;
8628: END IF;
8629:
8630: IF l_asgn_rec.expenditure_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8630: IF l_asgn_rec.expenditure_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8626: IF l_asgn_rec.expenditure_type_class = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8627: l_asgn_rec.expenditure_type_class := l_asgn_db_values_rec.expenditure_type_class ;
8628: END IF;
8629:
8630: IF l_asgn_rec.expenditure_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8631: l_asgn_rec.expenditure_type := l_asgn_db_values_rec.expenditure_type ;
8632: END IF;
8633:
8634: IF l_asgn_rec.work_type_id = G_PA_MISS_NUM THEN

Line 8648: IF l_asgn_rec.bill_rate_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

8644: IF l_asgn_rec.work_type_name = G_PA_MISS_CHAR THEN
8645: l_asgn_rec.work_type_name := null;
8646: END IF;
8647:
8648: IF l_asgn_rec.bill_rate_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8649: l_asgn_rec.bill_rate_override := l_asgn_db_values_rec.bill_rate_override;
8650: END IF;
8651:
8652: IF l_asgn_rec.bill_rate_curr_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8652: IF l_asgn_rec.bill_rate_curr_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8648: IF l_asgn_rec.bill_rate_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8649: l_asgn_rec.bill_rate_override := l_asgn_db_values_rec.bill_rate_override;
8650: END IF;
8651:
8652: IF l_asgn_rec.bill_rate_curr_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8653: l_asgn_rec.bill_rate_curr_override := l_asgn_db_values_rec.bill_rate_curr_override;
8654: END IF;
8655:
8656: IF l_asgn_rec.markup_percent_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 8656: IF l_asgn_rec.markup_percent_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

8652: IF l_asgn_rec.bill_rate_curr_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8653: l_asgn_rec.bill_rate_curr_override := l_asgn_db_values_rec.bill_rate_curr_override;
8654: END IF;
8655:
8656: IF l_asgn_rec.markup_percent_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8657: l_asgn_rec.markup_percent_override := l_asgn_db_values_rec.markup_percent_override;
8658: END IF;
8659:
8660: IF l_asgn_rec.discount_percentage = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 8660: IF l_asgn_rec.discount_percentage = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

8656: IF l_asgn_rec.markup_percent_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8657: l_asgn_rec.markup_percent_override := l_asgn_db_values_rec.markup_percent_override;
8658: END IF;
8659:
8660: IF l_asgn_rec.discount_percentage = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8661: l_asgn_rec.discount_percentage := l_asgn_db_values_rec.discount_percentage;
8662: END IF;
8663:
8664: IF l_asgn_rec.rate_disc_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8664: IF l_asgn_rec.rate_disc_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8660: IF l_asgn_rec.discount_percentage = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8661: l_asgn_rec.discount_percentage := l_asgn_db_values_rec.discount_percentage;
8662: END IF;
8663:
8664: IF l_asgn_rec.rate_disc_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8665: l_asgn_rec.rate_disc_reason_code := l_asgn_db_values_rec.rate_disc_reason_code;
8666: END IF;
8667:
8668: IF l_asgn_rec.tp_rate_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 8668: IF l_asgn_rec.tp_rate_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

8664: IF l_asgn_rec.rate_disc_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8665: l_asgn_rec.rate_disc_reason_code := l_asgn_db_values_rec.rate_disc_reason_code;
8666: END IF;
8667:
8668: IF l_asgn_rec.tp_rate_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8669: l_asgn_rec.tp_rate_override := l_asgn_db_values_rec.tp_rate_override;
8670: END IF;
8671:
8672: IF l_asgn_rec.tp_currency_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8672: IF l_asgn_rec.tp_currency_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8668: IF l_asgn_rec.tp_rate_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8669: l_asgn_rec.tp_rate_override := l_asgn_db_values_rec.tp_rate_override;
8670: END IF;
8671:
8672: IF l_asgn_rec.tp_currency_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8673: l_asgn_rec.tp_currency_override := l_asgn_db_values_rec.tp_currency_override;
8674: END IF;
8675:
8676: IF l_asgn_rec.tp_calc_base_code_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8676: IF l_asgn_rec.tp_calc_base_code_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8672: IF l_asgn_rec.tp_currency_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8673: l_asgn_rec.tp_currency_override := l_asgn_db_values_rec.tp_currency_override;
8674: END IF;
8675:
8676: IF l_asgn_rec.tp_calc_base_code_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8677: l_asgn_rec.tp_calc_base_code_override := l_asgn_db_values_rec.tp_calc_base_code_override;
8678: END IF;
8679:
8680: IF l_asgn_rec.tp_percent_applied_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 8680: IF l_asgn_rec.tp_percent_applied_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

8676: IF l_asgn_rec.tp_calc_base_code_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8677: l_asgn_rec.tp_calc_base_code_override := l_asgn_db_values_rec.tp_calc_base_code_override;
8678: END IF;
8679:
8680: IF l_asgn_rec.tp_percent_applied_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8681: l_asgn_rec.tp_percent_applied_override := l_asgn_db_values_rec.tp_percent_applied_override;
8682: END IF;
8683:
8684: IF l_asgn_rec.extension_possible = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8684: IF l_asgn_rec.extension_possible = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8680: IF l_asgn_rec.tp_percent_applied_override = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8681: l_asgn_rec.tp_percent_applied_override := l_asgn_db_values_rec.tp_percent_applied_override;
8682: END IF;
8683:
8684: IF l_asgn_rec.extension_possible = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8685: l_asgn_rec.extension_possible := l_asgn_db_values_rec.extension_possible;
8686: END IF;
8687:
8688: IF l_asgn_rec.expense_owner = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8688: IF l_asgn_rec.expense_owner = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8684: IF l_asgn_rec.extension_possible = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8685: l_asgn_rec.extension_possible := l_asgn_db_values_rec.extension_possible;
8686: END IF;
8687:
8688: IF l_asgn_rec.expense_owner = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8689: l_asgn_rec.expense_owner := l_asgn_db_values_rec.expense_owner;
8690: END IF;
8691:
8692: IF l_asgn_rec.expense_limit = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 8692: IF l_asgn_rec.expense_limit = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

8688: IF l_asgn_rec.expense_owner = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8689: l_asgn_rec.expense_owner := l_asgn_db_values_rec.expense_owner;
8690: END IF;
8691:
8692: IF l_asgn_rec.expense_limit = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8693: l_asgn_rec.expense_limit := l_asgn_db_values_rec.expense_limit;
8694: END IF;
8695:
8696: IF l_asgn_rec.orig_system_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8696: IF l_asgn_rec.orig_system_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8692: IF l_asgn_rec.expense_limit = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8693: l_asgn_rec.expense_limit := l_asgn_db_values_rec.expense_limit;
8694: END IF;
8695:
8696: IF l_asgn_rec.orig_system_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8697: l_asgn_rec.orig_system_code := l_asgn_db_values_rec.orig_system_code;
8698: END IF;
8699:
8700: IF l_asgn_rec.orig_system_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8700: IF l_asgn_rec.orig_system_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8696: IF l_asgn_rec.orig_system_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8697: l_asgn_rec.orig_system_code := l_asgn_db_values_rec.orig_system_code;
8698: END IF;
8699:
8700: IF l_asgn_rec.orig_system_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8701: l_asgn_rec.orig_system_reference := l_asgn_db_values_rec.orig_system_reference;
8702: END IF;
8703:
8704: IF l_asgn_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 8704: IF l_asgn_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

8700: IF l_asgn_rec.orig_system_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8701: l_asgn_rec.orig_system_reference := l_asgn_db_values_rec.orig_system_reference;
8702: END IF;
8703:
8704: IF l_asgn_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8705: l_asgn_rec.record_version_number := l_asgn_db_values_rec.record_version_number;
8706: END IF;
8707:
8708: IF l_asgn_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8708: IF l_asgn_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8704: IF l_asgn_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8705: l_asgn_rec.record_version_number := l_asgn_db_values_rec.record_version_number;
8706: END IF;
8707:
8708: IF l_asgn_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8709: l_asgn_rec.attribute_category := l_asgn_db_values_rec.attribute_category;
8710: END IF;
8711:
8712: IF l_asgn_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8712: IF l_asgn_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8708: IF l_asgn_rec.attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8709: l_asgn_rec.attribute_category := l_asgn_db_values_rec.attribute_category;
8710: END IF;
8711:
8712: IF l_asgn_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8713: l_asgn_rec.attribute1 := l_asgn_db_values_rec.attribute1;
8714: END IF;
8715:
8716: IF l_asgn_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8716: IF l_asgn_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8712: IF l_asgn_rec.attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8713: l_asgn_rec.attribute1 := l_asgn_db_values_rec.attribute1;
8714: END IF;
8715:
8716: IF l_asgn_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8717: l_asgn_rec.attribute2 := l_asgn_db_values_rec.attribute2;
8718: END IF;
8719:
8720: IF l_asgn_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8720: IF l_asgn_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8716: IF l_asgn_rec.attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8717: l_asgn_rec.attribute2 := l_asgn_db_values_rec.attribute2;
8718: END IF;
8719:
8720: IF l_asgn_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8721: l_asgn_rec.attribute3 := l_asgn_db_values_rec.attribute3;
8722: END IF;
8723:
8724: IF l_asgn_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8724: IF l_asgn_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8720: IF l_asgn_rec.attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8721: l_asgn_rec.attribute3 := l_asgn_db_values_rec.attribute3;
8722: END IF;
8723:
8724: IF l_asgn_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8725: l_asgn_rec.attribute4 := l_asgn_db_values_rec.attribute4;
8726: END IF;
8727:
8728: IF l_asgn_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8728: IF l_asgn_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8724: IF l_asgn_rec.attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8725: l_asgn_rec.attribute4 := l_asgn_db_values_rec.attribute4;
8726: END IF;
8727:
8728: IF l_asgn_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8729: l_asgn_rec.attribute5 := l_asgn_db_values_rec.attribute5;
8730: END IF;
8731:
8732: IF l_asgn_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8732: IF l_asgn_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8728: IF l_asgn_rec.attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8729: l_asgn_rec.attribute5 := l_asgn_db_values_rec.attribute5;
8730: END IF;
8731:
8732: IF l_asgn_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8733: l_asgn_rec.attribute6 := l_asgn_db_values_rec.attribute6;
8734: END IF;
8735:
8736: IF l_asgn_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8736: IF l_asgn_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8732: IF l_asgn_rec.attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8733: l_asgn_rec.attribute6 := l_asgn_db_values_rec.attribute6;
8734: END IF;
8735:
8736: IF l_asgn_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8737: l_asgn_rec.attribute7 := l_asgn_db_values_rec.attribute7;
8738: END IF;
8739:
8740: IF l_asgn_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8740: IF l_asgn_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8736: IF l_asgn_rec.attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8737: l_asgn_rec.attribute7 := l_asgn_db_values_rec.attribute7;
8738: END IF;
8739:
8740: IF l_asgn_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8741: l_asgn_rec.attribute8 := l_asgn_db_values_rec.attribute8;
8742: END IF;
8743:
8744: IF l_asgn_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8744: IF l_asgn_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8740: IF l_asgn_rec.attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8741: l_asgn_rec.attribute8 := l_asgn_db_values_rec.attribute8;
8742: END IF;
8743:
8744: IF l_asgn_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8745: l_asgn_rec.attribute9 := l_asgn_db_values_rec.attribute9;
8746: END IF;
8747:
8748: IF l_asgn_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8748: IF l_asgn_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8744: IF l_asgn_rec.attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8745: l_asgn_rec.attribute9 := l_asgn_db_values_rec.attribute9;
8746: END IF;
8747:
8748: IF l_asgn_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8749: l_asgn_rec.attribute10 :=l_asgn_db_values_rec.attribute10;
8750: END IF;
8751:
8752: IF l_asgn_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8752: IF l_asgn_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8748: IF l_asgn_rec.attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8749: l_asgn_rec.attribute10 :=l_asgn_db_values_rec.attribute10;
8750: END IF;
8751:
8752: IF l_asgn_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8753: l_asgn_rec.attribute11 := l_asgn_db_values_rec.attribute11;
8754: END IF;
8755:
8756: IF l_asgn_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8756: IF l_asgn_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8752: IF l_asgn_rec.attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8753: l_asgn_rec.attribute11 := l_asgn_db_values_rec.attribute11;
8754: END IF;
8755:
8756: IF l_asgn_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8757: l_asgn_rec.attribute12 :=l_asgn_db_values_rec.attribute12;
8758: END IF;
8759:
8760: IF l_asgn_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8760: IF l_asgn_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8756: IF l_asgn_rec.attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8757: l_asgn_rec.attribute12 :=l_asgn_db_values_rec.attribute12;
8758: END IF;
8759:
8760: IF l_asgn_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8761: l_asgn_rec.attribute13 :=l_asgn_db_values_rec.attribute13;
8762: END IF;
8763:
8764: IF l_asgn_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8764: IF l_asgn_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8760: IF l_asgn_rec.attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8761: l_asgn_rec.attribute13 :=l_asgn_db_values_rec.attribute13;
8762: END IF;
8763:
8764: IF l_asgn_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8765: l_asgn_rec.attribute14 := l_asgn_db_values_rec.attribute14;
8766: END IF;
8767:
8768: IF l_asgn_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 8768: IF l_asgn_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

8764: IF l_asgn_rec.attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8765: l_asgn_rec.attribute14 := l_asgn_db_values_rec.attribute14;
8766: END IF;
8767:
8768: IF l_asgn_rec.attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
8769: l_asgn_rec.attribute15 :=l_asgn_db_values_rec.attribute15;
8770: END IF;
8771:
8772:

Line 9587: PA_INTERFACE_UTILS_PUB.get_messages

9583: ROLLBACK TO UPDATE_ASSIGNMENTS_SP;
9584: END IF;
9585:
9586: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
9587: PA_INTERFACE_UTILS_PUB.get_messages
9588: ( p_encoded => FND_API.G_FALSE
9589: , p_msg_index => 1
9590: , p_msg_count => l_msg_count
9591: , p_msg_data => l_msg_data

Line 9858: IF l_req_rec.assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

9854: pa_debug.write(l_module, 'NullOut parameters which are not required.', l_debug_level);
9855: END IF;
9856:
9857: -- Blank Out Required Parameters if not passed.
9858: IF l_req_rec.assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
9859: l_req_rec.assignment_id := NULL ;
9860: END IF;
9861:
9862: IF l_req_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 9862: IF l_req_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

9858: IF l_req_rec.assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
9859: l_req_rec.assignment_id := NULL ;
9860: END IF;
9861:
9862: IF l_req_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
9863: l_req_rec.record_version_number := NULL ;
9864: END IF;
9865:
9866: IF l_debug_mode = 'Y' THEN

Line 10069: PA_INTERFACE_UTILS_PUB.GET_MESSAGES (

10065: CLOSE cur_get_system_status ;
10066: END IF;
10067:
10068: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
10069: PA_INTERFACE_UTILS_PUB.GET_MESSAGES (
10070: p_encoded => FND_API.G_FALSE
10071: , p_msg_index => 1
10072: , p_msg_count => l_msg_count
10073: , p_msg_data => l_msg_data

Line 10316: IF l_asgn_rec.assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

10312: l_asgn_rec := p_submit_assignment_in_tbl(i);
10313:
10314: -- Blank Out Parameters if not passed.
10315:
10316: IF l_asgn_rec.assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
10317: l_asgn_rec.assignment_id := NULL ;
10318: END IF;
10319:
10320: IF l_asgn_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 10320: IF l_asgn_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

10316: IF l_asgn_rec.assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
10317: l_asgn_rec.assignment_id := NULL ;
10318: END IF;
10319:
10320: IF l_asgn_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
10321: l_asgn_rec.record_version_number := NULL ;
10322: END IF;
10323:
10324: IF l_asgn_rec.auto_approve = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 10324: IF l_asgn_rec.auto_approve = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

10320: IF l_asgn_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
10321: l_asgn_rec.record_version_number := NULL ;
10322: END IF;
10323:
10324: IF l_asgn_rec.auto_approve = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
10325: l_asgn_rec.auto_approve := NULL ;
10326: END IF;
10327:
10328: IF l_asgn_rec.apr_person_id_1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 10328: IF l_asgn_rec.apr_person_id_1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

10324: IF l_asgn_rec.auto_approve = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
10325: l_asgn_rec.auto_approve := NULL ;
10326: END IF;
10327:
10328: IF l_asgn_rec.apr_person_id_1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
10329: l_asgn_rec.apr_person_id_1 := NULL ;
10330: END IF;
10331:
10332: IF l_asgn_rec.apr_person_id_2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 10332: IF l_asgn_rec.apr_person_id_2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

10328: IF l_asgn_rec.apr_person_id_1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
10329: l_asgn_rec.apr_person_id_1 := NULL ;
10330: END IF;
10331:
10332: IF l_asgn_rec.apr_person_id_2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
10333: l_asgn_rec.apr_person_id_2 := NULL ;
10334: END IF;
10335:
10336: IF l_asgn_rec.note_to_approver = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 10336: IF l_asgn_rec.note_to_approver = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

10332: IF l_asgn_rec.apr_person_id_2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
10333: l_asgn_rec.apr_person_id_2 := NULL ;
10334: END IF;
10335:
10336: IF l_asgn_rec.note_to_approver = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
10337: l_asgn_rec.note_to_approver := NULL ;
10338: END IF;
10339:
10340: l_assignment_id := l_asgn_rec.assignment_id ;

Line 10764: PA_INTERFACE_UTILS_PUB.get_messages

10760: ROLLBACK TO SUBMIT_ASSIGNMENTS_SP;
10761: END IF;
10762:
10763: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
10764: PA_INTERFACE_UTILS_PUB.get_messages
10765: ( p_encoded => FND_API.G_FALSE
10766: , p_msg_index => 1
10767: , p_msg_count => l_msg_count
10768: , p_msg_data => l_msg_data

Line 11011: IF l_competence_in_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11007: IF l_debug_mode = 'Y' THEN
11008: pa_debug.write(l_module, 'Start of Nulling out Params which are not passing for Record no '|| i , l_debug_level);
11009: END IF ;
11010: -- Nulling out unpassed params
11011: IF l_competence_in_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11012: l_competence_in_rec.requirement_id := NULL;
11013: END IF ;
11014:
11015: IF l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 11015: IF l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11011: IF l_competence_in_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11012: l_competence_in_rec.requirement_id := NULL;
11013: END IF ;
11014:
11015: IF l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11016: l_competence_in_rec.competence_element_id := NULL;
11017: END IF;
11018:
11019: IF l_competence_in_rec.competence_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 11019: IF l_competence_in_rec.competence_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11015: IF l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11016: l_competence_in_rec.competence_element_id := NULL;
11017: END IF;
11018:
11019: IF l_competence_in_rec.competence_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11020: l_competence_in_rec.competence_id := NULL;
11021: END IF;
11022:
11023: IF l_competence_in_rec.competence_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 11023: IF l_competence_in_rec.competence_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

11019: IF l_competence_in_rec.competence_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11020: l_competence_in_rec.competence_id := NULL;
11021: END IF;
11022:
11023: IF l_competence_in_rec.competence_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11024: l_competence_in_rec.competence_name := NULL;
11025: END IF ;
11026:
11027: IF l_competence_in_rec.competence_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 11027: IF l_competence_in_rec.competence_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

11023: IF l_competence_in_rec.competence_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11024: l_competence_in_rec.competence_name := NULL;
11025: END IF ;
11026:
11027: IF l_competence_in_rec.competence_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11028: l_competence_in_rec.competence_alias := NULL;
11029: END IF;
11030:
11031: IF l_competence_in_rec.rating_level_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 11031: IF l_competence_in_rec.rating_level_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11027: IF l_competence_in_rec.competence_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11028: l_competence_in_rec.competence_alias := NULL;
11029: END IF;
11030:
11031: IF l_competence_in_rec.rating_level_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11032: l_competence_in_rec.rating_level_id := NULL;
11033: END IF;
11034:
11035: IF l_competence_in_rec.rating_level_value = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 11035: IF l_competence_in_rec.rating_level_value = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11031: IF l_competence_in_rec.rating_level_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11032: l_competence_in_rec.rating_level_id := NULL;
11033: END IF;
11034:
11035: IF l_competence_in_rec.rating_level_value = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11036: l_competence_in_rec.rating_level_value := NULL;
11037: END IF;
11038:
11039: IF l_competence_in_rec.mandatory_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 11039: IF l_competence_in_rec.mandatory_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

11035: IF l_competence_in_rec.rating_level_value = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11036: l_competence_in_rec.rating_level_value := NULL;
11037: END IF;
11038:
11039: IF l_competence_in_rec.mandatory_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11040: l_competence_in_rec.mandatory_flag :=NULL;
11041: END IF;
11042:
11043: IF l_competence_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 11043: IF l_competence_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11039: IF l_competence_in_rec.mandatory_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11040: l_competence_in_rec.mandatory_flag :=NULL;
11041: END IF;
11042:
11043: IF l_competence_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11044: l_competence_in_rec.record_version_number :=NULL;
11045: END IF;
11046:
11047: IF l_debug_mode = 'Y' THEN

Line 11320: PA_INTERFACE_UTILS_PUB.GET_MESSAGES(

11316: ROLLBACK TO CREATE_REQU_COMPETENCE_SP;
11317: END IF;
11318:
11319: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
11320: PA_INTERFACE_UTILS_PUB.GET_MESSAGES(
11321: p_encoded => FND_API.G_FALSE
11322: , p_msg_index => 1
11323: , p_msg_count => l_msg_count
11324: , p_msg_data => l_msg_data

Line 11591: OR l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11587: l_miss_params := NULL;
11588: l_competence_in_rec := P_COMPETENCE_IN_TBL(i);
11589:
11590: IF l_competence_in_rec.competence_element_id IS NULL
11591: OR l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11592: l_miss_params := l_miss_params || 'P_COMPETENCE_ELEMENT_ID';
11593: END IF;
11594:
11595: IF l_miss_params IS NOT NULL THEN

Line 11609: AND l_competence_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11605: l_competence_id := l_competence_in_rec.competence_id;
11606: l_competence_element_id := l_competence_in_rec.competence_element_id;
11607: -- Getting the Data about competence
11608: IF l_competence_element_id IS NOT NULL
11609: AND l_competence_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11610:
11611: OPEN cur_competence_details(l_competence_element_id);
11612: FETCH cur_competence_details INTO l_cur_competence_in_rec;
11613: -- checking the validity of l_competence_element_id

Line 11650: OR l_competence_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11646: l_competence_in_rec.competence_name := l_cur_competence_in_rec.competence_name;
11647: l_competence_in_rec.competence_alias := l_cur_competence_in_rec.competence_alias;
11648:
11649: IF l_competence_in_rec.record_version_number IS NULL
11650: OR l_competence_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11651:
11652: l_competence_in_rec.record_version_number := l_cur_competence_in_rec.object_version_number;
11653:
11654: END IF;

Line 11657: IF l_competence_in_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11653:
11654: END IF;
11655: END IF;
11656: -- Taking care of miss char value..
11657: IF l_competence_in_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11658: l_competence_in_rec.requirement_id := FND_API.G_MISS_NUM;
11659: END IF ;
11660:
11661: IF l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 11661: IF l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11657: IF l_competence_in_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11658: l_competence_in_rec.requirement_id := FND_API.G_MISS_NUM;
11659: END IF ;
11660:
11661: IF l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11662: l_competence_in_rec.competence_element_id := FND_API.G_MISS_NUM;
11663: END IF;
11664:
11665: IF l_competence_in_rec.competence_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 11665: IF l_competence_in_rec.competence_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11661: IF l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11662: l_competence_in_rec.competence_element_id := FND_API.G_MISS_NUM;
11663: END IF;
11664:
11665: IF l_competence_in_rec.competence_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11666: l_competence_in_rec.competence_id := FND_API.G_MISS_NUM;
11667: END IF;
11668:
11669: IF l_competence_in_rec.competence_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 11669: IF l_competence_in_rec.competence_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

11665: IF l_competence_in_rec.competence_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11666: l_competence_in_rec.competence_id := FND_API.G_MISS_NUM;
11667: END IF;
11668:
11669: IF l_competence_in_rec.competence_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11670: l_competence_in_rec.competence_name := FND_API.G_MISS_CHAR;
11671: END IF ;
11672:
11673: IF l_competence_in_rec.competence_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 11673: IF l_competence_in_rec.competence_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

11669: IF l_competence_in_rec.competence_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11670: l_competence_in_rec.competence_name := FND_API.G_MISS_CHAR;
11671: END IF ;
11672:
11673: IF l_competence_in_rec.competence_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11674: l_competence_in_rec.competence_alias := FND_API.G_MISS_CHAR;
11675: END IF;
11676:
11677: IF l_competence_in_rec.rating_level_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 11677: IF l_competence_in_rec.rating_level_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11673: IF l_competence_in_rec.competence_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11674: l_competence_in_rec.competence_alias := FND_API.G_MISS_CHAR;
11675: END IF;
11676:
11677: IF l_competence_in_rec.rating_level_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11678: l_competence_in_rec.rating_level_id := FND_API.G_MISS_NUM;
11679: END IF;
11680:
11681: IF l_competence_in_rec.rating_level_value = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 11681: IF l_competence_in_rec.rating_level_value = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11677: IF l_competence_in_rec.rating_level_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11678: l_competence_in_rec.rating_level_id := FND_API.G_MISS_NUM;
11679: END IF;
11680:
11681: IF l_competence_in_rec.rating_level_value = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11682: l_competence_in_rec.rating_level_value := FND_API.G_MISS_NUM;
11683: END IF;
11684:
11685: IF l_competence_in_rec.mandatory_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 11685: IF l_competence_in_rec.mandatory_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

11681: IF l_competence_in_rec.rating_level_value = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11682: l_competence_in_rec.rating_level_value := FND_API.G_MISS_NUM;
11683: END IF;
11684:
11685: IF l_competence_in_rec.mandatory_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11686: l_competence_in_rec.mandatory_flag :=FND_API.G_MISS_CHAR;
11687: END IF;
11688:
11689: IF l_competence_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 11689: IF l_competence_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

11685: IF l_competence_in_rec.mandatory_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
11686: l_competence_in_rec.mandatory_flag :=FND_API.G_MISS_CHAR;
11687: END IF;
11688:
11689: IF l_competence_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
11690: l_competence_in_rec.record_version_number :=FND_API.G_MISS_NUM;
11691: END IF;
11692: --- Security check
11693:

Line 11903: PA_INTERFACE_UTILS_PUB.GET_MESSAGES(

11899: ROLLBACK TO UPDATE_REQU_COMPETENCE_SP;
11900: END IF;
11901:
11902: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
11903: PA_INTERFACE_UTILS_PUB.GET_MESSAGES(
11904: p_encoded => FND_API.G_FALSE
11905: , p_msg_index => 1
11906: , p_msg_count => l_msg_count
11907: , p_msg_data => l_msg_data

Line 12158: l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

12154: l_miss_params := NULL;
12155: l_competence_in_rec := P_COMPETENCE_IN_TBL(i);
12156: -- check for missparams.......
12157: IF l_competence_in_rec.competence_element_id IS NULL OR
12158: l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
12159: l_miss_params := l_miss_params || 'COMPETENCE_ELEMENT_ID';
12160: END IF;
12161:
12162: IF l_miss_params IS NOT NULL THEN

Line 12188: OR l_competence_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

12184:
12185: IF l_local_error_flag <> 'Y' THEN
12186:
12187: IF l_competence_in_rec.record_version_number IS NULL
12188: OR l_competence_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
12189:
12190: l_competence_in_rec.record_version_number :=l_cur_competence_in_rec.object_version_number;
12191:
12192: END IF;

Line 12407: PA_INTERFACE_UTILS_PUB.GET_MESSAGES(

12403: ROLLBACK TO DELETE_REQU_COMPETENCE_SP;
12404: END IF;
12405:
12406: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
12407: PA_INTERFACE_UTILS_PUB.GET_MESSAGES(
12408: p_encoded => FND_API.G_FALSE
12409: , p_msg_index => 1
12410: , p_msg_count => l_msg_count
12411: , p_msg_data => l_msg_data

Line 12677: IF l_candidate_in_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

12673: END IF;
12674:
12675: -- Blank Out Parameters if not passed
12676: -------------------------------------
12677: IF l_candidate_in_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
12678: l_candidate_in_rec.requirement_id := null;
12679: END IF;
12680:
12681: IF l_candidate_in_rec.resource_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 12681: IF l_candidate_in_rec.resource_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

12677: IF l_candidate_in_rec.requirement_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
12678: l_candidate_in_rec.requirement_id := null;
12679: END IF;
12680:
12681: IF l_candidate_in_rec.resource_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
12682: l_candidate_in_rec.resource_id := null;
12683: END IF;
12684:
12685: IF l_candidate_in_rec.person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 12685: IF l_candidate_in_rec.person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

12681: IF l_candidate_in_rec.resource_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
12682: l_candidate_in_rec.resource_id := null;
12683: END IF;
12684:
12685: IF l_candidate_in_rec.person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
12686: l_candidate_in_rec.person_id := null;
12687: END IF;
12688:
12689: IF l_candidate_in_rec.status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 12689: IF l_candidate_in_rec.status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

12685: IF l_candidate_in_rec.person_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
12686: l_candidate_in_rec.person_id := null;
12687: END IF;
12688:
12689: IF l_candidate_in_rec.status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
12690: l_candidate_in_rec.status_code := 107; -- Default to Pending Review
12691: END IF;
12692:
12693: IF l_candidate_in_rec.nomination_comments = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 12693: IF l_candidate_in_rec.nomination_comments = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

12689: IF l_candidate_in_rec.status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
12690: l_candidate_in_rec.status_code := 107; -- Default to Pending Review
12691: END IF;
12692:
12693: IF l_candidate_in_rec.nomination_comments = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
12694: l_candidate_in_rec.nomination_comments := null;
12695: END IF;
12696:
12697: -- Null out the parameters which are not required in create flow

Line 13027: PA_INTERFACE_UTILS_PUB.get_messages

13023: ROLLBACK TO CREATE_CANDIDATES_SP;
13024: END IF;
13025:
13026: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
13027: PA_INTERFACE_UTILS_PUB.get_messages
13028: ( p_encoded => FND_API.G_FALSE
13029: , p_msg_index => 1
13030: , p_msg_count => l_msg_count
13031: , p_msg_data => l_msg_data

Line 13276: IF l_candidate_in_rec.status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

13272:
13273: CLOSE c_get_candidate_details;
13274:
13275: -- Check on Status Code
13276: IF l_candidate_in_rec.status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
13277: l_candidate_in_rec.status_code := l_cand_rec.status_code;
13278: ELSIF l_candidate_in_rec.status_code IS NOT NULL THEN
13279: l_project_system_status_code := null;
13280:

Line 13315: IF l_candidate_in_rec.ranking = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

13311: IF l_debug_mode = 'Y' THEN
13312: pa_debug.write(l_module, 'Retrieving values from database if parameters are not passed.', l_log_level);
13313: END IF;
13314:
13315: IF l_candidate_in_rec.ranking = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
13316: l_candidate_in_rec.ranking := l_cand_rec.candidate_ranking;
13317: END IF;
13318:
13319: IF l_candidate_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 13319: IF l_candidate_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

13315: IF l_candidate_in_rec.ranking = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
13316: l_candidate_in_rec.ranking := l_cand_rec.candidate_ranking;
13317: END IF;
13318:
13319: IF l_candidate_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
13320: l_candidate_in_rec.record_version_number := l_cand_rec.record_version_number;
13321: END IF;
13322:
13323: -- If Change Reason Code is not passed then use null

Line 13324: IF l_candidate_in_rec.change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

13320: l_candidate_in_rec.record_version_number := l_cand_rec.record_version_number;
13321: END IF;
13322:
13323: -- If Change Reason Code is not passed then use null
13324: IF l_candidate_in_rec.change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
13325: l_candidate_in_rec.change_reason_code := null;
13326: END IF;
13327:
13328: IF l_debug_mode = 'Y' THEN

Line 13548: PA_INTERFACE_UTILS_PUB.get_messages

13544: ROLLBACK TO UPDATE_CANDIDATES_SP;
13545: END IF;
13546:
13547: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
13548: PA_INTERFACE_UTILS_PUB.get_messages
13549: ( p_encoded => FND_API.G_FALSE
13550: , p_msg_index => 1
13551: , p_msg_count => l_msg_count
13552: , p_msg_data => l_msg_data

Line 13989: PA_INTERFACE_UTILS_PUB.get_messages

13985: ROLLBACK TO DELETE_CANDIDATES_SP;
13986: END IF;
13987:
13988: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
13989: PA_INTERFACE_UTILS_PUB.get_messages
13990: ( p_encoded => FND_API.G_FALSE
13991: , p_msg_index => 1
13992: , p_msg_count => l_msg_count
13993: , p_msg_data => l_msg_data

Line 14225: IF l_candidate_log_tbl.status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

14221:
14222: CLOSE c_get_candidate_details;
14223:
14224: -- Check on Status Code
14225: IF l_candidate_log_tbl.status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14226: l_candidate_log_tbl.status_code := null;
14227: ELSIF l_candidate_log_tbl.status_code IS NOT NULL THEN
14228: l_project_system_status_code := null;
14229:

Line 14242: IF l_candidate_log_tbl.change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

14238: END IF;
14239: END IF;
14240:
14241: -- Check for Change Reason Code
14242: IF l_candidate_log_tbl.change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14243: l_candidate_log_tbl.change_reason_code := null;
14244: ELSIF l_candidate_log_tbl.change_reason_code IS NOT NULL THEN
14245:
14246: OPEN c_get_valid_lookup_code(l_candidate_log_tbl.change_reason_code);

Line 14271: IF l_candidate_log_tbl.review_comments = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

14267: IF l_error_flag_local <> 'Y' THEN
14268:
14269:
14270: -- Check for Review Comments
14271: IF l_candidate_log_tbl.review_comments = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14272: l_candidate_log_tbl.review_comments := null;
14273: END IF;
14274:
14275: -- Security Check : Check PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in CandRevwLogTopCO.java

Line 14474: PA_INTERFACE_UTILS_PUB.get_messages

14470: ROLLBACK TO CREATE_CANDIDATE_LOG_SP;
14471: END IF;
14472:
14473: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
14474: PA_INTERFACE_UTILS_PUB.get_messages
14475: ( p_encoded => FND_API.G_FALSE
14476: , p_msg_index => 1
14477: , p_msg_count => l_msg_count
14478: , p_msg_data => l_msg_data