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_ASSIGNMENT_APPROVAL_PUB dependencies on PA_ASSIGNMENT_APPROVAL_PVT

Line 298: PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required(p_assignment_id => p_assignment_id

294: ,'Submitting an approval.', 5);
295: END IF;
296:
297: --Check if approval is required
298: PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required(p_assignment_id => p_assignment_id
299: ,p_new_assignment_flag => p_new_assignment_flag
300: ,x_approval_required_flag => l_approval_required_flag
301: ,x_return_status => l_return_status);
302:

Line 336: PA_ASSIGNMENT_APPROVAL_PVT.Validate_Approver_Orders (x_return_status => l_return_status);

332: PA_DEBUG.write_log ('pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.enabled'
333: ,'Workflow is enabled. Now validating approvers order.',5);
334:
335: --Validate Approvers Order
336: PA_ASSIGNMENT_APPROVAL_PVT.Validate_Approver_Orders (x_return_status => l_return_status);
337: END IF; --end of workflow enabled
338: */
339: -- if approval is not required
340: ELSE

Line 417: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status(p_assignment_id => p_assignment_id

413: END IF;
414: --------------------------------------------------------------------------------------------------------
415: -- Update Approval Status
416: --------------------------------------------------------------------------------------------------------
417: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status(p_assignment_id => p_assignment_id
418: ,p_action_code => l_action_code
419: ,p_note_to_approver => p_note_to_approver
420: ,p_record_version_number => p_record_version_number
421: ,x_apprvl_status_code => l_apprvl_status_code

Line 639: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Start_Assignment_Approvals'

635: ROLLBACK TO ASG_APR_PUB_START_APPRVL;
636: END IF;
637:
638: -- Set the exception Message and the stack
639: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Start_Assignment_Approvals'
640: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
642:
643: --clear PL/SQL table for next time

Line 715: ELSIF PA_ASSIGNMENT_APPROVAL_PVT.is_new_assignment(p_assignment_id => p_assignment_id) = 'Y' THEN

711: IF PA_ASGMT_WFSTD.is_approval_pending(p_assignment_id => p_assignment_id) = 'Y' THEN
712:
713: PA_UTILS.Add_Message( p_app_short_name => 'PA'
714: ,p_msg_name => 'PA_WF_APPROVAL_PENDING');
715: ELSIF PA_ASSIGNMENT_APPROVAL_PVT.is_new_assignment(p_assignment_id => p_assignment_id) = 'Y' THEN
716: PA_UTILS.Add_Message( p_app_short_name => 'PA'
717: ,p_msg_name => 'PA_NO_APPRV_ASGMT_TO_REVERT');
718: ELSE
719: --

Line 923: PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action ( p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action

919:
920: --
921: --Get the Assignment Approval Status after reverting
922: --
923: PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action ( p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action
924: ,p_status_code => l_apprvl_status_code
925: ,x_status_code => l_next_status_code
926: ,x_return_status => l_return_status);
927:

Line 1250: x_new_assignment_flag := PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment(p_assignment_id => p_assignment_id);

1246:
1247: ---------------------------------------------------------------------------
1248: -- Check if it is a New Assignemnt
1249: ---------------------------------------------------------------------------
1250: x_new_assignment_flag := PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment(p_assignment_id => p_assignment_id);
1251:
1252: -- Check if approval is required to pass the out parameter 'x_approval_required_flag'
1253: PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required( p_assignment_id => p_assignment_id
1254: ,p_new_assignment_flag => x_new_assignment_flag

Line 1253: PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required( p_assignment_id => p_assignment_id

1249: ---------------------------------------------------------------------------
1250: x_new_assignment_flag := PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment(p_assignment_id => p_assignment_id);
1251:
1252: -- Check if approval is required to pass the out parameter 'x_approval_required_flag'
1253: PA_ASSIGNMENT_APPROVAL_PVT.Check_Approval_Required( p_assignment_id => p_assignment_id
1254: ,p_new_assignment_flag => x_new_assignment_flag
1255: ,x_approval_required_flag => x_approval_required_flag
1256: ,x_return_status => l_return_status);
1257:

Line 1268: PA_ASSIGNMENT_APPROVAL_PVT.get_asmt_and_asmt_history_rec

1264:
1265: ---------------------------------------------------------------------------
1266: -- Generate history_asmt_rec and latest updated_asmt_rec
1267: ---------------------------------------------------------------------------
1268: PA_ASSIGNMENT_APPROVAL_PVT.get_asmt_and_asmt_history_rec
1269: (p_assignment_id => p_assignment_id
1270: ,x_saved_asmt_rec => l_saved_asmt_rec
1271: ,x_asmt_history_rec => l_asmt_history_rec
1272: ,x_return_status => l_return_status);

Line 1318: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'ADDITIONAL_STAFF_INFO');

1314: -- Populate Table for the updated assignment items
1315: ------------------------------------------------------------------------------
1316:
1317: -- Compare Additional Staffing Information
1318: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'ADDITIONAL_STAFF_INFO');
1319: IF (NVL(l_asmt_history_rec.additional_information,-1) <> NVL(l_updated_asmt_rec.additional_information,-1)) THEN
1320: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1321: VALUES (p_assignment_id,l_changed_item,l_updated_asmt_rec.additional_information,l_asmt_history_rec.additional_information);
1322: END IF;

Line 1325: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'ASMT_EXP_TYPE');

1321: VALUES (p_assignment_id,l_changed_item,l_updated_asmt_rec.additional_information,l_asmt_history_rec.additional_information);
1322: END IF;
1323:
1324: -- Compare Expenditure Type
1325: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'ASMT_EXP_TYPE');
1326: IF (NVL(l_asmt_history_rec.expenditure_type,-1) <> NVL(l_updated_asmt_rec.expenditure_type,-1)) THEN
1327: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1328: VALUES (p_assignment_id, l_changed_item, l_updated_asmt_rec.expenditure_type, l_asmt_history_rec.expenditure_type);
1329: END IF;

Line 1332: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'ASSIGNMENT_NAME');

1328: VALUES (p_assignment_id, l_changed_item, l_updated_asmt_rec.expenditure_type, l_asmt_history_rec.expenditure_type);
1329: END IF;
1330:
1331: -- Compare Assignment Name
1332: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'ASSIGNMENT_NAME');
1333: IF (NVL(l_asmt_history_rec.assignment_name,-1) <> NVL(l_updated_asmt_rec.assignment_name,-1)) THEN
1334: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1335: VALUES (p_assignment_id, l_changed_item, l_updated_asmt_rec.assignment_name, l_asmt_history_rec.assignment_name);
1336: END IF;

Line 1339: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'DESCRIPTION');

1335: VALUES (p_assignment_id, l_changed_item, l_updated_asmt_rec.assignment_name, l_asmt_history_rec.assignment_name);
1336: END IF;
1337:
1338: -- Compare Description
1339: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'DESCRIPTION');
1340: IF (NVL(l_asmt_history_rec.description,-1) <> NVL(l_updated_asmt_rec.description,-1)) THEN
1341: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1342: VALUES (p_assignment_id, l_changed_item, l_updated_asmt_rec.description, l_asmt_history_rec.description);
1343: END IF;

Line 1346: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'EXPENSE_LIMIT');

1342: VALUES (p_assignment_id, l_changed_item, l_updated_asmt_rec.description, l_asmt_history_rec.description);
1343: END IF;
1344:
1345: -- Compare Expense Limit
1346: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'EXPENSE_LIMIT');
1347: IF (NVL(l_asmt_history_rec.expense_limit,-1) <> NVL(l_updated_asmt_rec.expense_limit,-1)) THEN
1348: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1349: VALUES (p_assignment_id, l_changed_item, to_char(l_updated_asmt_rec.expense_limit),
1350: to_char(l_asmt_history_rec.expense_limit));

Line 1354: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'EXPENSE_OWNER');

1350: to_char(l_asmt_history_rec.expense_limit));
1351: END IF;
1352:
1353: -- Compare Expense Owner
1354: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'EXPENSE_OWNER');
1355: IF (NVL(l_asmt_history_rec.expense_owner,-1) <> NVL(l_updated_asmt_rec.expense_owner,-1)) THEN
1356: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('EXPENSE_OWNER_TYPE', l_updated_asmt_rec.expense_owner);
1357: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('EXPENSE_OWNER_TYPE', l_asmt_history_rec.expense_owner);
1358:

Line 1356: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('EXPENSE_OWNER_TYPE', l_updated_asmt_rec.expense_owner);

1352:
1353: -- Compare Expense Owner
1354: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'EXPENSE_OWNER');
1355: IF (NVL(l_asmt_history_rec.expense_owner,-1) <> NVL(l_updated_asmt_rec.expense_owner,-1)) THEN
1356: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('EXPENSE_OWNER_TYPE', l_updated_asmt_rec.expense_owner);
1357: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('EXPENSE_OWNER_TYPE', l_asmt_history_rec.expense_owner);
1358:
1359: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1360: VALUES (p_assignment_id, l_changed_item, l_new_value, l_old_value);

Line 1357: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('EXPENSE_OWNER_TYPE', l_asmt_history_rec.expense_owner);

1353: -- Compare Expense Owner
1354: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'EXPENSE_OWNER');
1355: IF (NVL(l_asmt_history_rec.expense_owner,-1) <> NVL(l_updated_asmt_rec.expense_owner,-1)) THEN
1356: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('EXPENSE_OWNER_TYPE', l_updated_asmt_rec.expense_owner);
1357: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('EXPENSE_OWNER_TYPE', l_asmt_history_rec.expense_owner);
1358:
1359: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1360: VALUES (p_assignment_id, l_changed_item, l_new_value, l_old_value);
1361: END IF;

Line 1364: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'EXTENSION_POSSIBLE');

1360: VALUES (p_assignment_id, l_changed_item, l_new_value, l_old_value);
1361: END IF;
1362:
1363: -- Compare Extension Possible
1364: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'EXTENSION_POSSIBLE');
1365: IF (NVL(l_asmt_history_rec.extension_possible,-1) <> NVL(l_updated_asmt_rec.extension_possible,-1)) THEN
1366: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1367: VALUES (p_assignment_id, l_changed_item, l_updated_asmt_rec.extension_possible, l_asmt_history_rec.extension_possible);
1368: END IF;

Line 1371: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'LOCATION');

1367: VALUES (p_assignment_id, l_changed_item, l_updated_asmt_rec.extension_possible, l_asmt_history_rec.extension_possible);
1368: END IF;
1369:
1370: -- Compare Location
1371: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'LOCATION');
1372: IF (NVL(l_asmt_history_rec.location_id,-1) <> NVL(l_updated_asmt_rec.location_id,-1)) THEN
1373: FOR c2 IN get_locations(l_asmt_history_rec.location_id, l_updated_asmt_rec.location_id) LOOP
1374: IF c2.location_id = l_updated_asmt_rec.location_id THEN
1375: l_new_city := c2.city;

Line 1391: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'STAFFING_PRIORITY');

1387: l_old_city||', ' || l_old_region || ', ' || l_old_country_code);
1388: END IF;
1389:
1390: -- Compare Staffing Priority
1391: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'STAFFING_PRIORITY');
1392: IF (NVL(l_asmt_history_rec.staffing_priority_code,-1) <> NVL(l_updated_asmt_rec.staffing_priority_code,-1)) THEN
1393: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('STAFFING_PRIORITY_CODE', l_updated_asmt_rec.staffing_priority_code);
1394: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('STAFFING_PRIORITY_CODE', l_asmt_history_rec.staffing_priority_code);
1395:

Line 1393: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('STAFFING_PRIORITY_CODE', l_updated_asmt_rec.staffing_priority_code);

1389:
1390: -- Compare Staffing Priority
1391: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'STAFFING_PRIORITY');
1392: IF (NVL(l_asmt_history_rec.staffing_priority_code,-1) <> NVL(l_updated_asmt_rec.staffing_priority_code,-1)) THEN
1393: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('STAFFING_PRIORITY_CODE', l_updated_asmt_rec.staffing_priority_code);
1394: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('STAFFING_PRIORITY_CODE', l_asmt_history_rec.staffing_priority_code);
1395:
1396: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1397: VALUES (p_assignment_id, l_changed_item, l_new_value, l_old_value);

Line 1394: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('STAFFING_PRIORITY_CODE', l_asmt_history_rec.staffing_priority_code);

1390: -- Compare Staffing Priority
1391: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'STAFFING_PRIORITY');
1392: IF (NVL(l_asmt_history_rec.staffing_priority_code,-1) <> NVL(l_updated_asmt_rec.staffing_priority_code,-1)) THEN
1393: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('STAFFING_PRIORITY_CODE', l_updated_asmt_rec.staffing_priority_code);
1394: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('STAFFING_PRIORITY_CODE', l_asmt_history_rec.staffing_priority_code);
1395:
1396: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1397: VALUES (p_assignment_id, l_changed_item, l_new_value, l_old_value);
1398: END IF;

Line 1401: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'SUB_TEAM');

1397: VALUES (p_assignment_id, l_changed_item, l_new_value, l_old_value);
1398: END IF;
1399:
1400: -- Compare project Subteam
1401: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'SUB_TEAM');
1402:
1403: -- get project_subteam_id from pa_project_subteam_parties
1404: OPEN get_project_subteam_id;
1405: FETCH get_project_subteam_id INTO l_project_subteam_id;

Line 1434: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'STAFFING_OWNER');

1430: VALUES (p_assignment_id, l_changed_item, l_new_subteam_name, l_old_subteam_name);
1431: END IF;
1432:
1433: -- Compare Staffing Owner
1434: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'STAFFING_OWNER');
1435:
1436: IF (NVL(l_asmt_history_rec.staffing_owner_person_id,-1) <> NVL(l_updated_asmt_rec.staffing_owner_person_id,-1)) THEN
1437: -- If p_staffing_owner_person_id=null and p_staffing_owner_name<>null(when user just type name instead of
1438: -- using LOV in Mass Update page), l_updated_asmt_rec.staffing_owner_person_id won't have the latest

Line 1457: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TRANSFER_AMT_TYPE');

1453: VALUES (p_assignment_id, l_changed_item, l_new_value, l_old_value);
1454: END IF;
1455:
1456: -- Compare TP Amount Type
1457: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TRANSFER_AMT_TYPE');
1458:
1459: IF (NVL(l_asmt_history_rec.fcst_tp_amount_type,-1) <> NVL(l_updated_asmt_rec.fcst_tp_amount_type,-1)) THEN
1460: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('TP_AMOUNT_TYPE', l_updated_asmt_rec.fcst_tp_amount_type);
1461: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('TP_AMOUNT_TYPE', l_asmt_history_rec.fcst_tp_amount_type);

Line 1460: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('TP_AMOUNT_TYPE', l_updated_asmt_rec.fcst_tp_amount_type);

1456: -- Compare TP Amount Type
1457: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TRANSFER_AMT_TYPE');
1458:
1459: IF (NVL(l_asmt_history_rec.fcst_tp_amount_type,-1) <> NVL(l_updated_asmt_rec.fcst_tp_amount_type,-1)) THEN
1460: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('TP_AMOUNT_TYPE', l_updated_asmt_rec.fcst_tp_amount_type);
1461: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('TP_AMOUNT_TYPE', l_asmt_history_rec.fcst_tp_amount_type);
1462:
1463: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1464: VALUES (p_assignment_id, l_changed_item, l_new_value, l_old_value);

Line 1461: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('TP_AMOUNT_TYPE', l_asmt_history_rec.fcst_tp_amount_type);

1457: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TRANSFER_AMT_TYPE');
1458:
1459: IF (NVL(l_asmt_history_rec.fcst_tp_amount_type,-1) <> NVL(l_updated_asmt_rec.fcst_tp_amount_type,-1)) THEN
1460: l_new_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('TP_AMOUNT_TYPE', l_updated_asmt_rec.fcst_tp_amount_type);
1461: l_old_value := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('TP_AMOUNT_TYPE', l_asmt_history_rec.fcst_tp_amount_type);
1462:
1463: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1464: VALUES (p_assignment_id, l_changed_item, l_new_value, l_old_value);
1465: END IF;

Line 1468: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'WORK_TYPE');

1464: VALUES (p_assignment_id, l_changed_item, l_new_value, l_old_value);
1465: END IF;
1466:
1467: -- Compare Work Type
1468: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'WORK_TYPE');
1469:
1470: IF (NVL(l_asmt_history_rec.work_type_id,-1) <> NVL(l_updated_asmt_rec.work_type_id,-1)) THEN
1471: FOR c2 IN get_work_type_names(l_asmt_history_rec.work_type_id, l_updated_asmt_rec.work_type_id) LOOP
1472: IF c2.work_type_id = l_updated_asmt_rec.work_type_id THEN

Line 1484: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TP_CURRENCY_OVERRIDE');

1480: VALUES (p_assignment_id, l_changed_item, l_new_work_type, l_old_work_type);
1481: END IF;
1482:
1483: -- Compare Transfer Price Currency Override
1484: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TP_CURRENCY_OVERRIDE');
1485:
1486: IF (NVL(l_asmt_history_rec.tp_currency_override,-1) <> NVL(l_updated_asmt_rec.tp_currency_override,-1)) THEN
1487: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1488: VALUES (p_assignment_id, l_changed_item, l_updated_asmt_rec.tp_currency_override,

Line 1493: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TP_RATE_OVERRIDE');

1489: l_asmt_history_rec.tp_currency_override);
1490: END IF;
1491:
1492: -- Compare Transfer Price Rate Override
1493: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TP_RATE_OVERRIDE');
1494:
1495: IF (NVL(l_asmt_history_rec.tp_rate_override,-1) <> NVL(l_updated_asmt_rec.tp_rate_override,-1)) THEN
1496: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1497: VALUES (p_assignment_id, l_changed_item, to_char(l_updated_asmt_rec.tp_rate_override),

Line 1502: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TP_CALC_BASE_CODE_OVERRIDE');

1498: to_char(l_asmt_history_rec.tp_rate_override));
1499: END IF;
1500:
1501: -- Compare Transfer Price Basis Override
1502: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TP_CALC_BASE_CODE_OVERRIDE');
1503:
1504: IF (NVL(l_asmt_history_rec.tp_calc_base_code_override,-1) <> NVL(l_updated_asmt_rec.tp_calc_base_code_override,-1)) THEN
1505: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1506: VALUES (p_assignment_id, l_changed_item, l_updated_asmt_rec.tp_calc_base_code_override,

Line 1511: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TP_PERCENT_APPLIED_OVERRIDE');

1507: l_asmt_history_rec.tp_calc_base_code_override);
1508: END IF;
1509:
1510: -- Compare Transfer Price Apply % Override
1511: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'TP_PERCENT_APPLIED_OVERRIDE');
1512:
1513: IF (NVL(l_asmt_history_rec.tp_percent_applied_override,-1) <> NVL(l_updated_asmt_rec.tp_percent_applied_override,-1)) THEN
1514: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)
1515: VALUES (p_assignment_id, l_changed_item, to_char(l_updated_asmt_rec.tp_percent_applied_override),

Line 1524: l_change_id := PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id (p_assignment_id);

1520: ---------------------------------------------------------------------------
1521: -- Populate Table for the updated schedule items
1522: ---------------------------------------------------------------------------
1523: -- get change_id just to check, it will pass -1 if the history table has no record for this asmt
1524: l_change_id := PA_ASSIGNMENT_APPROVAL_PVT.Get_Change_Id (p_assignment_id);
1525:
1526: PA_SCHEDULE_PVT.update_asgmt_changed_items_tab (
1527: p_assignment_id => p_assignment_id
1528: ,p_populate_mode => p_populate_mode

Line 1886: PA_ASSIGNMENT_APPROVAL_PVT.Abort_Assignment_Approval(p_assignment_id => p_assignment_id

1882: --IF pending approval, then abort
1883: IF PA_ASGMT_WFSTD.Is_Approval_Pending (p_assignment_id => p_assignment_id) = 'Y' THEN
1884: --dbms_output.put_line('abort assignment');
1885:
1886: PA_ASSIGNMENT_APPROVAL_PVT.Abort_Assignment_Approval(p_assignment_id => p_assignment_id
1887: ,p_project_id => l_project_id
1888: ,x_return_status => x_return_status);
1889: --dbms_output.put_line('abort assignment result:'||x_return_status);
1890: END IF;

Line 1985: l_new_assignment_flag := PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment(p_assignment_id => p_assignment_id);

1981:
1982: END IF; -- end of checking source assignment id
1983:
1984: --Update apprvl_status_code and send notification if necessary
1985: l_new_assignment_flag := PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment(p_assignment_id => p_assignment_id);
1986: --dbms_output.put_line('new assignment flag'||l_new_assignment_flag);
1987:
1988: -- update the assignment approval status and send notification when the canceled assignment
1989: -- has ever been approved.

Line 2007: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status(

2003: --Else if full duration cancel, just set cancel status
2004: ELSIF l_full_cancel_flag = 'Y' THEN
2005:
2006: -- Update apprvl_status_code
2007: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status(
2008: P_ASSIGNMENT_ID => p_assignment_id
2009: ,P_ACTION_CODE => PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action
2010: ,P_RECORD_VERSION_NUMBER => NULL
2011: ,X_APPRVL_STATUS_CODE => l_apprvl_status_code

Line 3179: l_new_asgmt_flag := PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment( l_assignment_id_tbl(i) );

3175: --can be processed for assignment approval
3176: ------------------------------------------------------------------
3177: IF l_assignment_status = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action THEN
3178:
3179: l_new_asgmt_flag := PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment( l_assignment_id_tbl(i) );
3180:
3181: IF l_new_asgmt_flag = 'N' THEN
3182:
3183: PA_ASSIGNMENT_APPROVAL_PVT.check_approval_required

Line 3183: PA_ASSIGNMENT_APPROVAL_PVT.check_approval_required

3179: l_new_asgmt_flag := PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment( l_assignment_id_tbl(i) );
3180:
3181: IF l_new_asgmt_flag = 'N' THEN
3182:
3183: PA_ASSIGNMENT_APPROVAL_PVT.check_approval_required
3184: ( l_assignment_id_tbl(i)
3185: ,l_new_asgmt_flag
3186: ,x_aprvl_required
3187: ,l_return_status );

Line 3219: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status

3215: OPEN get_rec_num ( l_assignment_id_tbl(i) );
3216: FETCH get_rec_num INTO p_record_version_number;
3217: CLOSE get_rec_num;
3218:
3219: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status
3220: ( p_assignment_id => l_assignment_id_tbl(i)
3221: ,p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action
3222: ,p_note_to_approver => p_note_to_all_approvers
3223: ,p_record_version_number => p_record_version_number

Line 3308: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status

3304: CLOSE get_rec_num;
3305:
3306: log_message('Record version number: ' || p_record_version_number );
3307:
3308: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status
3309: ( p_assignment_id => l_assignment_id_tbl(i)
3310: ,p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action
3311: ,p_note_to_approver => p_note_to_all_approvers
3312: ,p_record_version_number => p_record_version_number