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_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 1199: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE

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

Line 1223: l_assignment_name pa_project_assignments.assignment_name%TYPE;

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

Line 1224: l_start_date pa_project_assignments.start_date%TYPE;

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

Line 1225: l_end_date pa_project_assignments.end_date%TYPE;

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

Line 1228: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;

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

Line 1229: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;

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

Line 1231: l_description pa_project_assignments.description%TYPE;

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

Line 1232: l_additional_information pa_project_assignments.additional_information%TYPE;

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

Line 1242: l_effort pa_project_assignments.assignment_effort%TYPE;

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

Line 1260: l_transfer_price_rate pa_project_assignments.transfer_price_rate%type;

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

Line 1261: l_transfer_pr_rate_curr pa_project_assignments.transfer_pr_rate_curr%type;

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

Line 1295: FROM pa_project_assignments asgn,

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

Line 1401: FROM pa_project_assignments

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

Line 1629: , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE

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

Line 1630: , p_record_version_number IN pa_project_assignments.record_version_number%TYPE

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

Line 1670: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row

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

Line 2002: FROM pa_project_assignments

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

Line 2262: v_assig_id pa_project_assignments.assignment_id%type;

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

Line 2270: select 'Y' into v_dummy from pa_project_assignments

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