DBA Data[Home] [Help]

APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 42: l_start_date pa_project_assignments.start_date%TYPE;

38: l_condition_attribute2_tbl varchar_tbl;
39: l_action_line_id_tbl2 pa_action_set_utils.number_tbl_type;
40: l_condition_date_tbl2 pa_action_set_utils.date_tbl_type;
41: l_action_line_number_tbl2 pa_action_set_utils.number_tbl_type;
42: l_start_date pa_project_assignments.start_date%TYPE;
43: l_adv_action_set_status_code pa_action_sets.status_code%TYPE;
44: l_adv_action_set_start_date pa_action_sets.actual_start_date%TYPE;
45: l_action_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
46: l_action_line_cond_id_tbl2 pa_action_set_utils.number_tbl_type;

Line 54: FROM pa_project_assignments pa,

50: CURSOR get_req_action_set_info IS
51: SELECT pa.start_date,
52: ast.status_code,
53: ast.actual_start_date
54: FROM pa_project_assignments pa,
55: pa_action_sets ast
56: WHERE pa.assignment_id = ast.object_id
57: AND ast.action_set_id = p_action_set_id;
58:

Line 1006: , p_project_id IN pa_project_assignments.project_id%TYPE

1002: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1003: , p_method IN VARCHAR2
1004: , p_person_id IN pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM
1005: , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
1006: , p_project_id IN pa_project_assignments.project_id%TYPE
1007: , p_insert_audit_flag IN VARCHAR2 := 'T'
1008: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1009: --, x_msg_count OUT NUMBER
1010: --, x_msg_data OUT VARCHAR2

Line 1198: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE

1194: , p_ntf_recipient_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
1195: , p_wf_user_name IN VARCHAR2 := NULL
1196: , p_wf_process IN VARCHAR2
1197: , p_wf_item_type IN VARCHAR2 := 'PARADVWF'
1198: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1199: , p_project_id IN pa_projects_all.project_id%TYPE
1200: , p_insert_audit_flag IN VARCHAR2 := 'T'
1201: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1202: ) IS

Line 1222: l_assignment_name pa_project_assignments.assignment_name%TYPE;

1218: l_display_name VARCHAR2(240);
1219: l_save_threshold NUMBER;
1220: l_wf_item_type VARCHAR2(8);
1221:
1222: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1223: l_start_date pa_project_assignments.start_date%TYPE;
1224: l_end_date pa_project_assignments.end_date%TYPE;
1225: l_project_organization_name hr_organization_units.name%TYPE;
1226: l_project_role_name pa_project_role_types.meaning%TYPE;

Line 1223: l_start_date pa_project_assignments.start_date%TYPE;

1219: l_save_threshold NUMBER;
1220: l_wf_item_type VARCHAR2(8);
1221:
1222: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1223: l_start_date pa_project_assignments.start_date%TYPE;
1224: l_end_date pa_project_assignments.end_date%TYPE;
1225: l_project_organization_name hr_organization_units.name%TYPE;
1226: l_project_role_name pa_project_role_types.meaning%TYPE;
1227: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;

Line 1224: l_end_date pa_project_assignments.end_date%TYPE;

1220: l_wf_item_type VARCHAR2(8);
1221:
1222: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1223: l_start_date pa_project_assignments.start_date%TYPE;
1224: l_end_date pa_project_assignments.end_date%TYPE;
1225: l_project_organization_name hr_organization_units.name%TYPE;
1226: l_project_role_name pa_project_role_types.meaning%TYPE;
1227: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1228: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;

Line 1227: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;

1223: l_start_date pa_project_assignments.start_date%TYPE;
1224: l_end_date pa_project_assignments.end_date%TYPE;
1225: l_project_organization_name hr_organization_units.name%TYPE;
1226: l_project_role_name pa_project_role_types.meaning%TYPE;
1227: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1228: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1229: l_staffing_priority_name VARCHAR2(80);
1230: l_description pa_project_assignments.description%TYPE;
1231: l_additional_information pa_project_assignments.additional_information%TYPE;

Line 1228: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;

1224: l_end_date pa_project_assignments.end_date%TYPE;
1225: l_project_organization_name hr_organization_units.name%TYPE;
1226: l_project_role_name pa_project_role_types.meaning%TYPE;
1227: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1228: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1229: l_staffing_priority_name VARCHAR2(80);
1230: l_description pa_project_assignments.description%TYPE;
1231: l_additional_information pa_project_assignments.additional_information%TYPE;
1232: l_project_name pa_projects_all.name%TYPE;

Line 1230: l_description pa_project_assignments.description%TYPE;

1226: l_project_role_name pa_project_role_types.meaning%TYPE;
1227: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1228: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1229: l_staffing_priority_name VARCHAR2(80);
1230: l_description pa_project_assignments.description%TYPE;
1231: l_additional_information pa_project_assignments.additional_information%TYPE;
1232: l_project_name pa_projects_all.name%TYPE;
1233: l_project_number pa_projects_all.segment1%TYPE;
1234: l_project_organization HR_ALL_ORGANIZATION_UNITS.name%TYPE;

Line 1231: l_additional_information pa_project_assignments.additional_information%TYPE;

1227: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1228: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1229: l_staffing_priority_name VARCHAR2(80);
1230: l_description pa_project_assignments.description%TYPE;
1231: l_additional_information pa_project_assignments.additional_information%TYPE;
1232: l_project_name pa_projects_all.name%TYPE;
1233: l_project_number pa_projects_all.segment1%TYPE;
1234: l_project_organization HR_ALL_ORGANIZATION_UNITS.name%TYPE;
1235: -- 4363092 TCA changes, replaced RA views with HZ tables

Line 1241: l_effort pa_project_assignments.assignment_effort%TYPE;

1237: l_project_customer hz_parties.party_name%TYPE;
1238: -- 4363092 done
1239: l_project_manager per_all_people_f.full_name%TYPE;
1240: l_project_manager_id pa_project_parties.resource_source_id%TYPE;
1241: l_effort pa_project_assignments.assignment_effort%TYPE;
1242: l_duration NUMBER;
1243: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
1244: l_index NUMBER;
1245: l_requirement_overview_link VARCHAR2(2000);

Line 1259: l_transfer_price_rate pa_project_assignments.transfer_price_rate%type;

1255: l_tp_calc_base_code_override VARCHAR2(30);
1256: l_tp_percent_applied_override NUMBER;
1257: l_work_type_name VARCHAR2(80);
1258: /* Bug 3051110-Added the following variables */
1259: l_transfer_price_rate pa_project_assignments.transfer_price_rate%type;
1260: l_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%type;
1261: l_override_basis_name VARCHAR2(80) := NULL;
1262:
1263: --cursor to get attributes of the requirement to be

Line 1260: l_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%type;

1256: l_tp_percent_applied_override NUMBER;
1257: l_work_type_name VARCHAR2(80);
1258: /* Bug 3051110-Added the following variables */
1259: l_transfer_price_rate pa_project_assignments.transfer_price_rate%type;
1260: l_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%type;
1261: l_override_basis_name VARCHAR2(80) := NULL;
1262:
1263: --cursor to get attributes of the requirement to be
1264: --displayed in notifications

Line 1294: FROM pa_project_assignments asgn,

1290: asgn.tp_percent_applied_override,
1291: wt.name,
1292: asgn.transfer_price_rate, -- Added for bug 3051110
1293: asgn.transfer_pr_rate_curr
1294: FROM pa_project_assignments asgn,
1295: pa_projects_all proj,
1296: pa_project_role_types prt,
1297: pa_lookups sp,
1298: pa_lookups fcst,

Line 1400: FROM pa_project_assignments

1396: IF p_wf_user_name IS NOT NULL THEN
1397:
1398: SELECT -999
1399: BULK COLLECT INTO l_ntf_recipient_person_id_tbl
1400: FROM pa_project_assignments
1401: WHERE assignment_id = p_assignment_id;
1402:
1403: ELSE
1404: l_ntf_recipient_person_id_tbl := p_ntf_recipient_person_id_tbl;

Line 1628: , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE

1624: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
1625: , p_object_id IN pa_action_sets.object_id%TYPE
1626: , p_action_code IN pa_action_set_lines.action_code%TYPE
1627: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1628: , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
1629: , p_record_version_number IN pa_project_assignments.record_version_number%TYPE
1630: , p_insert_audit_flag IN VARCHAR2 := 'T'
1631: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1632: ) IS

Line 1629: , p_record_version_number IN pa_project_assignments.record_version_number%TYPE

1625: , p_object_id IN pa_action_sets.object_id%TYPE
1626: , p_action_code IN pa_action_set_lines.action_code%TYPE
1627: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1628: , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
1629: , p_record_version_number IN pa_project_assignments.record_version_number%TYPE
1630: , p_insert_audit_flag IN VARCHAR2 := 'T'
1631: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1632: ) IS
1633:

Line 1669: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row

1665: WHERE lookup_type = 'STAFFING_PRIORITY_CODE'
1666: AND lookup_code = p_staffing_priority_code;
1667:
1668: -- Update the staffing priority code
1669: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row
1670: ( p_assignment_id => p_object_id
1671: ,p_record_version_number => p_record_version_number
1672: ,p_staffing_priority_code => p_staffing_priority_code
1673: ,x_return_status => x_return_status );

Line 2001: FROM pa_project_assignments

1997:
1998: -- get object information
1999: SELECT project_id, record_version_number
2000: INTO l_project_id, l_record_version_number
2001: FROM pa_project_assignments
2002: WHERE assignment_id = p_object_id;
2003:
2004: -- handle send notifications, send email and update staffing priority
2005: FOR i IN l_action_set_line_id_tbl.FIRST .. l_action_set_line_id_tbl.LAST LOOP

Line 2261: v_assig_id pa_project_assignments.assignment_id%type;

2257: , funcmode IN VARCHAR2
2258: , resultout OUT NOCOPY VARCHAR2 --NOCOPY required for OUT and IN/OUT parameters
2259: ) IS
2260: v_dummy varchar2(1);
2261: v_assig_id pa_project_assignments.assignment_id%type;
2262:
2263: BEGIN
2264:
2265: v_assig_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 2269: select 'Y' into v_dummy from pa_project_assignments

2265: v_assig_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2266: itemkey => itemkey,
2267: aname => 'ASSIGNMENT_ID' );
2268:
2269: select 'Y' into v_dummy from pa_project_assignments
2270: where assignment_id = v_assig_id
2271: and STATUS_CODE in
2272: (select PROJECT_STATUS_CODE from pa_project_statuses
2273: where PROJECT_SYSTEM_STATUS_CODE = 'OPEN_ASGMT');