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_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.3.12010000.3 2008/12/11 22:20:49 snizam 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.3.12010000.3 2008/12/11 22:20:49 snizam 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.3.12010000.3 2008/12/11 22:20:49 snizam 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 2591: PA_INTERFACE_UTILS_PUB.get_messages

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

Line 4600: PA_INTERFACE_UTILS_PUB.get_messages

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

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

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

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

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

Line 4993: PA_INTERFACE_UTILS_PUB.get_messages

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5655: PA_INTERFACE_UTILS_PUB.get_messages

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

Line 5888: IF l_req_asgn_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

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

Line 6089: PA_INTERFACE_UTILS_PUB.get_messages

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

Line 7880: PA_INTERFACE_UTILS_PUB.get_messages

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 9585: PA_INTERFACE_UTILS_PUB.get_messages

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

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

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

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

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

Line 10067: PA_INTERFACE_UTILS_PUB.GET_MESSAGES (

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 10762: PA_INTERFACE_UTILS_PUB.get_messages

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 11318: PA_INTERFACE_UTILS_PUB.GET_MESSAGES(

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

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

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

Line 11607: AND l_competence_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 11901: PA_INTERFACE_UTILS_PUB.GET_MESSAGES(

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

Line 12156: l_competence_in_rec.competence_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

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

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

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

Line 12405: PA_INTERFACE_UTILS_PUB.GET_MESSAGES(

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

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

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

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

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

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

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

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

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

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

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

Line 13006: PA_INTERFACE_UTILS_PUB.get_messages

13002: ROLLBACK TO CREATE_CANDIDATES_SP;
13003: END IF;
13004:
13005: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
13006: PA_INTERFACE_UTILS_PUB.get_messages
13007: ( p_encoded => FND_API.G_FALSE
13008: , p_msg_index => 1
13009: , p_msg_count => l_msg_count
13010: , p_msg_data => l_msg_data

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

13251:
13252: CLOSE c_get_candidate_details;
13253:
13254: -- Check on Status Code
13255: IF l_candidate_in_rec.status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
13256: l_candidate_in_rec.status_code := l_cand_rec.status_code;
13257: ELSIF l_candidate_in_rec.status_code IS NOT NULL THEN
13258: l_project_system_status_code := null;
13259:

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

13290: IF l_debug_mode = 'Y' THEN
13291: pa_debug.write(l_module, 'Retrieving values from database if parameters are not passed.', l_log_level);
13292: END IF;
13293:
13294: IF l_candidate_in_rec.ranking = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
13295: l_candidate_in_rec.ranking := l_cand_rec.candidate_ranking;
13296: END IF;
13297:
13298: IF l_candidate_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

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

13294: IF l_candidate_in_rec.ranking = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
13295: l_candidate_in_rec.ranking := l_cand_rec.candidate_ranking;
13296: END IF;
13297:
13298: IF l_candidate_in_rec.record_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
13299: l_candidate_in_rec.record_version_number := l_cand_rec.record_version_number;
13300: END IF;
13301:
13302: -- If Change Reason Code is not passed then use null

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

13299: l_candidate_in_rec.record_version_number := l_cand_rec.record_version_number;
13300: END IF;
13301:
13302: -- If Change Reason Code is not passed then use null
13303: IF l_candidate_in_rec.change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
13304: l_candidate_in_rec.change_reason_code := null;
13305: END IF;
13306:
13307: IF l_debug_mode = 'Y' THEN

Line 13510: PA_INTERFACE_UTILS_PUB.get_messages

13506: ROLLBACK TO UPDATE_CANDIDATES_SP;
13507: END IF;
13508:
13509: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
13510: PA_INTERFACE_UTILS_PUB.get_messages
13511: ( p_encoded => FND_API.G_FALSE
13512: , p_msg_index => 1
13513: , p_msg_count => l_msg_count
13514: , p_msg_data => l_msg_data

Line 13951: PA_INTERFACE_UTILS_PUB.get_messages

13947: ROLLBACK TO DELETE_CANDIDATES_SP;
13948: END IF;
13949:
13950: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
13951: PA_INTERFACE_UTILS_PUB.get_messages
13952: ( p_encoded => FND_API.G_FALSE
13953: , p_msg_index => 1
13954: , p_msg_count => l_msg_count
13955: , p_msg_data => l_msg_data

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

14183:
14184: CLOSE c_get_candidate_details;
14185:
14186: -- Check on Status Code
14187: IF l_candidate_log_tbl.status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14188: l_candidate_log_tbl.status_code := null;
14189: ELSIF l_candidate_log_tbl.status_code IS NOT NULL THEN
14190: l_project_system_status_code := null;
14191:

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

14200: END IF;
14201: END IF;
14202:
14203: -- Check for Change Reason Code
14204: IF l_candidate_log_tbl.change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14205: l_candidate_log_tbl.change_reason_code := null;
14206: ELSIF l_candidate_log_tbl.change_reason_code IS NOT NULL THEN
14207:
14208: OPEN c_get_valid_lookup_code(l_candidate_log_tbl.change_reason_code);

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

14229: IF l_error_flag_local <> 'Y' THEN
14230:
14231:
14232: -- Check for Review Comments
14233: IF l_candidate_log_tbl.review_comments = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14234: l_candidate_log_tbl.review_comments := null;
14235: END IF;
14236:
14237: -- Security Check : Check PA_REVIEW_CANDIDATE_LOG privilege on PA_PROJECTS and PA_PROJECT_ASSIGNMENTS as done in CandRevwLogTopCO.java

Line 14419: PA_INTERFACE_UTILS_PUB.get_messages

14415: ROLLBACK TO CREATE_CANDIDATE_LOG_SP;
14416: END IF;
14417:
14418: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
14419: PA_INTERFACE_UTILS_PUB.get_messages
14420: ( p_encoded => FND_API.G_FALSE
14421: , p_msg_index => 1
14422: , p_msg_count => l_msg_count
14423: , p_msg_data => l_msg_data