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_ACTION_SET_UTILS

Line 39: l_action_line_id_tbl2 pa_action_set_utils.number_tbl_type;

35: l_action_code_tbl varchar_tbl;
36: l_condition_code_tbl varchar_tbl;
37: l_condition_attribute1_tbl varchar_tbl;
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;

Line 40: l_condition_date_tbl2 pa_action_set_utils.date_tbl_type;

36: l_condition_code_tbl varchar_tbl;
37: l_condition_attribute1_tbl varchar_tbl;
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;

Line 41: l_action_line_number_tbl2 pa_action_set_utils.number_tbl_type;

37: l_condition_attribute1_tbl varchar_tbl;
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;

Line 45: l_action_line_cond_id_tbl pa_action_set_utils.number_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;
47: l_return_status VARCHAR2(1);
48:
49: --cursor to get the related details of the requirement

Line 46: l_action_line_cond_id_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;
47: l_return_status VARCHAR2(1);
48:
49: --cursor to get the related details of the requirement
50: CURSOR get_req_action_set_info IS

Line 317: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;

313: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
314: ) IS
315:
316: l_return_status VARCHAR2(1);
317: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
318: l_index NUMBER;
319:
320: BEGIN
321:

Line 394: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;

390: INDEX BY BINARY_INTEGER;
391:
392: l_organization_name_tbl varchar_tbl;
393: l_organization_id_tbl number_tbl;
394: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
395: l_index NUMBER;
396: l_encoded_message_text VARCHAR2(2000);
397: l_msg_index_out NUMBER;
398:

Line 445: PA_ACTION_SET_UTILS.Add_Message(

441: IF l_organization_id_tbl.COUNT = 0 THEN
442:
443: -- insert error into error stack, get the encoded message
444: -- and insert into audit table
445: PA_ACTION_SET_UTILS.Add_Message(
446: p_app_short_name => 'PA'
447: ,p_msg_name => 'PA_ADV_PUB_ORG_ERR'
448: );
449:

Line 514: , p_action_set_line_cond_tbl IN pa_action_set_utils.action_line_cond_tbl_type

510: , p_action_set_line_rec_ver_num IN pa_action_set_lines.record_version_number%TYPE
511: , p_object_id IN pa_action_sets.object_id%TYPE
512: , p_action_code IN pa_action_set_lines.action_code%TYPE
513: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
514: , p_action_set_line_cond_tbl IN pa_action_set_utils.action_line_cond_tbl_type
515: , p_insert_audit_flag IN VARCHAR2 := 'T'
516: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
517: ) IS
518:

Line 522: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;

518:
519: l_org_hierarchy_version_id per_org_structure_versions.org_structure_version_id%TYPE;
520: l_start_org_id hr_organization_units.organization_id%TYPE;
521: l_new_start_org_id hr_organization_units.organization_id%TYPE;
522: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
523: l_index NUMBER;
524: l_msg_count NUMBER;
525: l_msg_data VARCHAR2(2000);
526: l_encoded_message_text VARCHAR2(2000);

Line 627: PA_ACTION_SET_UTILS.Add_Message(

623: If l_new_start_org_id is null THEN
624:
625: -- insert error into error stack, get the encoded message
626: -- and insert into audit table
627: PA_ACTION_SET_UTILS.Add_Message(
628: p_app_short_name => 'PA'
629: ,p_msg_name => 'PA_ADV_ESC_LVL_ERR'
630: );
631:

Line 736: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;

732: INDEX BY BINARY_INTEGER;
733:
734: l_person_name_tbl varchar_tbl;
735: l_person_id_tbl number_tbl;
736: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
737: l_index NUMBER;
738: l_encoded_message_text VARCHAR2(2000);
739: l_msg_index_out NUMBER;
740:

Line 797: PA_ACTION_SET_UTILS.Add_Message(

793: -- ERROR: Insert error into the stack when there is no people
794: -- with project authority in the organization
795: IF l_person_id_tbl.COUNT = 0 THEN
796: -- insert error to stack
797: PA_ACTION_SET_UTILS.Add_Message(
798: p_app_short_name => 'PA'
799: ,p_msg_name => 'PA_ADV_PUB_SM_ERR'
800: );
801:

Line 872: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;

868: l_return_status VARCHAR2(1);
869: l_wf_adhoc_user_name VARCHAR2(240);
870: l_wf_adhoc_display_name VARCHAR2(240);
871: l_wf_process VARCHAR2(30);
872: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
873: l_index NUMBER;
874: l_encoded_message_text VARCHAR2(2000);
875: l_msg_index_out NUMBER;
876: l_action_status_code VARCHAR2(30);

Line 1061: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;

1057: l_return_status VARCHAR2(1);
1058: l_wf_process VARCHAR2(30);
1059: l_encoded_message_text VARCHAR2(2000);
1060: l_msg_index_out NUMBER;
1061: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
1062: l_index NUMBER;
1063: l_action_status_code VARCHAR2(30);
1064:
1065: BEGIN

Line 1105: PA_ACTION_SET_UTILS.Add_Message(

1101:
1102: IF p_action_code = 'ADVERTISEMENT_SEND_NTF_PERSON' THEN
1103:
1104: -- insert error into audit, 'User is not valid'
1105: PA_ACTION_SET_UTILS.Add_Message(
1106: p_app_short_name => 'PA'
1107: ,p_msg_name => 'PA_ADV_NTF_PERSON_ERR'
1108: );
1109:

Line 1112: PA_ACTION_SET_UTILS.Add_Message(

1108: );
1109:
1110: ELSIF p_action_code = 'ADVERTISEMENT_SEND_NTF_ROLE' THEN
1111: -- insert error into audit, Person does not exists for the project role
1112: PA_ACTION_SET_UTILS.Add_Message(
1113: p_app_short_name => 'PA'
1114: ,p_msg_name => 'PA_ADV_NTF_ROLE_ERR'
1115: );
1116:

Line 1243: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;

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);
1246:
1247: l_revenue_bill_rate NUMBER;

Line 1427: PA_ACTION_SET_UTILS.Add_Message(

1423: IF l_ntf_recipient_user_name IS NULL THEN
1424:
1425: --dbms_output.put_line('no username for person id '|| l_ntf_recipient_person_id_tbl(i));
1426: -- insert error into audit, User is not valid
1427: PA_ACTION_SET_UTILS.Add_Message(
1428: p_app_short_name => 'PA'
1429: ,p_msg_name => 'PA_ADV_NTF_ERR'
1430: ,p_token1 => 'PERSON_NAME'
1431: ,p_value1 => p_ntf_recipient_name_tbl(i)

Line 1635: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;

1631: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1632: ) IS
1633:
1634: l_staffing_priority_name pa_lookups.meaning%TYPE;
1635: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
1636: l_index NUMBER;
1637: l_encoded_message_text VARCHAR2(2000);
1638: l_msg_index_out NUMBER;
1639: l_update_sp_display_attribute VARCHAR2(80);

Line 1771: l_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;

1767: TYPE varchar_tbl IS TABLE OF VARCHAR2(150)
1768: INDEX BY BINARY_INTEGER;
1769:
1770: l_return_status VARCHAR2(1);
1771: l_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
1772: l_action_code_tbl varchar_tbl;
1773: l_audit_attribute_tbl varchar_tbl;
1774: l_display_audit_attribute_tbl varchar_tbl;
1775: l_line_status_tbl pa_action_set_utils.varchar_tbl_type;

Line 1775: l_line_status_tbl pa_action_set_utils.varchar_tbl_type;

1771: l_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
1772: l_action_code_tbl varchar_tbl;
1773: l_audit_attribute_tbl varchar_tbl;
1774: l_display_audit_attribute_tbl varchar_tbl;
1775: l_line_status_tbl pa_action_set_utils.varchar_tbl_type;
1776: l_action_set_line_id_tbl2 pa_action_set_utils.number_tbl_type;
1777: l_line_status_tbl2 pa_action_set_utils.varchar_tbl_type;
1778:
1779: i NUMBER;

Line 1776: l_action_set_line_id_tbl2 pa_action_set_utils.number_tbl_type;

1772: l_action_code_tbl varchar_tbl;
1773: l_audit_attribute_tbl varchar_tbl;
1774: l_display_audit_attribute_tbl varchar_tbl;
1775: l_line_status_tbl pa_action_set_utils.varchar_tbl_type;
1776: l_action_set_line_id_tbl2 pa_action_set_utils.number_tbl_type;
1777: l_line_status_tbl2 pa_action_set_utils.varchar_tbl_type;
1778:
1779: i NUMBER;
1780: l_action_status_code VARCHAR2(30);

Line 1777: l_line_status_tbl2 pa_action_set_utils.varchar_tbl_type;

1773: l_audit_attribute_tbl varchar_tbl;
1774: l_display_audit_attribute_tbl varchar_tbl;
1775: l_line_status_tbl pa_action_set_utils.varchar_tbl_type;
1776: l_action_set_line_id_tbl2 pa_action_set_utils.number_tbl_type;
1777: l_line_status_tbl2 pa_action_set_utils.varchar_tbl_type;
1778:
1779: i NUMBER;
1780: l_action_status_code VARCHAR2(30);
1781: l_action_set_id NUMBER;

Line 1787: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;

1783: l_object_type VARCHAR2(30);
1784: l_action_set_type_code VARCHAR2(30);
1785: l_project_id NUMBER;
1786: l_record_version_number NUMBER;
1787: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
1788: l_index NUMBER;
1789: l_encoded_message_text VARCHAR2(2000);
1790: l_msg_index_out NUMBER;
1791: l_audit_reason_code VARCHAR2(30);