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_MASS_ASGMT_TRX dependencies on PA_NUM_TBL_TYPE

Line 7: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

3:
4: PROCEDURE start_mass_asgmt_trx_wf
5: (p_mode IN VARCHAR2
6: ,p_action IN VARCHAR2
7: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
8: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
9: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
10: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
11: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

Line 8: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

4: PROCEDURE start_mass_asgmt_trx_wf
5: (p_mode IN VARCHAR2
6: ,p_action IN VARCHAR2
7: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
8: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
9: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
10: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
11: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

Line 81: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

77: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
78: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
79: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
80: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
81: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
82: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
83: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
84: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
85: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 82: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

78: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
79: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
80: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
81: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
82: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
83: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
84: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
85: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
86: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 83: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

79: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
80: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
81: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
82: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
83: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
84: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
85: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
86: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
87: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 84: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

80: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
81: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
82: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
83: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
84: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
85: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
86: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
87: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
88: ,p_non_working_day_flag IN VARCHAR2 := 'N'

Line 85: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

81: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
82: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
83: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
84: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
85: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
86: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
87: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
88: ,p_non_working_day_flag IN VARCHAR2 := 'N'
89: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 86: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

82: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
83: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
84: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
85: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
86: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
87: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
88: ,p_non_working_day_flag IN VARCHAR2 := 'N'
89: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
90: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM

Line 87: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

83: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
84: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
85: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
86: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
87: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
88: ,p_non_working_day_flag IN VARCHAR2 := 'N'
89: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
90: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
91: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM

Line 98: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

94: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
95: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
97: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
98: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
99: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
100: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
101: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
102: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 100: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

96: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
97: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
98: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
99: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
100: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
101: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
102: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
103: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
104: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

Line 104: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

100: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
101: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
102: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
103: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
104: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
105: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
106: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
107: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
108: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := pa_empty_varchar2_1_tbl

Line 107: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

103: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
104: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
105: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
106: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
107: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
108: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := pa_empty_varchar2_1_tbl
109: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
110: ,x_return_status OUT NOCOPY VARCHAR2 -- 4537865
111: )

Line 138: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

134: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;
135: l_err_code fnd_new_messages.message_name%TYPE;
136: l_err_stage VARCHAR2(2000);
137: l_err_stack VARCHAR2(2000);
138: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
139: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
140: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
141: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
142: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

Line 139: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

135: l_err_code fnd_new_messages.message_name%TYPE;
136: l_err_stage VARCHAR2(2000);
137: l_err_stack VARCHAR2(2000);
138: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
139: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
140: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
141: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
142: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
143: l_project_id pa_projects_all.project_id%TYPE;

Line 141: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

137: l_err_stack VARCHAR2(2000);
138: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
139: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
140: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
141: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
142: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
143: l_project_id pa_projects_all.project_id%TYPE;
144: l_fcst_tp_amount_type_name VARCHAR2(80);
145: /* Commented for bug 9114634

Line 772: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

768: IS
769:
770: l_mode VARCHAR2(30);
771: l_action VARCHAR2(30);
772: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
773: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
774: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
775: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
776: l_asgmt_overcom_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 773: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

769:
770: l_mode VARCHAR2(30);
771: l_action VARCHAR2(30);
772: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
773: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
774: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
775: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
776: l_asgmt_overcom_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
777: l_project_id pa_project_assignments.project_id%TYPE;

Line 774: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

770: l_mode VARCHAR2(30);
771: l_action VARCHAR2(30);
772: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
773: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
774: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
775: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
776: l_asgmt_overcom_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
777: l_project_id pa_project_assignments.project_id%TYPE;
778: l_start_date pa_project_assignments.start_date%TYPE;

Line 775: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

771: l_action VARCHAR2(30);
772: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
773: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
774: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
775: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
776: l_asgmt_overcom_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
777: l_project_id pa_project_assignments.project_id%TYPE;
778: l_start_date pa_project_assignments.start_date%TYPE;
779: l_end_date pa_project_assignments.end_date%TYPE;

Line 776: l_asgmt_overcom_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

772: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
773: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
774: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
775: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
776: l_asgmt_overcom_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
777: l_project_id pa_project_assignments.project_id%TYPE;
778: l_start_date pa_project_assignments.start_date%TYPE;
779: l_end_date pa_project_assignments.end_date%TYPE;
780: l_project_name pa_projects_all.name%TYPE;

Line 823: l_success_assignment_id_tbl2 SYSTEM.pa_num_tbl_type ;

819: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;
820: l_change_id NUMBER;
821: l_record_version_number NUMBER;
822: l_note_to_all_approvers VARCHAR(2000);
823: l_success_assignment_id_tbl2 SYSTEM.pa_num_tbl_type ;
824: ----Added following code for bug 6199871 and 9114634-----------------------
825:
826:
827: TYPE success_failure_count_tbl IS TABLE OF NUMBER

Line 1240: p_resource_id_tbl IN SYSTEM.pa_num_tbl_type,

1236: (p_item_type IN VARCHAR2,
1237: p_item_key IN VARCHAR2,
1238: p_actid IN NUMBER,
1239: p_funcmode IN VARCHAR2,
1240: p_resource_id_tbl IN SYSTEM.pa_num_tbl_type,
1241: p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,
1242: x_mode OUT NOCOPY VARCHAR2, -- 4537865
1243: x_action OUT NOCOPY VARCHAR2, -- 4537865
1244: x_start_date OUT NOCOPY DATE, -- 4537865

Line 1241: p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,

1237: p_item_key IN VARCHAR2,
1238: p_actid IN NUMBER,
1239: p_funcmode IN VARCHAR2,
1240: p_resource_id_tbl IN SYSTEM.pa_num_tbl_type,
1241: p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,
1242: x_mode OUT NOCOPY VARCHAR2, -- 4537865
1243: x_action OUT NOCOPY VARCHAR2, -- 4537865
1244: x_start_date OUT NOCOPY DATE, -- 4537865
1245: x_end_date OUT NOCOPY DATE, -- 4537865

Line 1270: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1266: PRAGMA AUTONOMOUS_TRANSACTION;
1267:
1268: l_mode VARCHAR2(30);
1269: l_action VARCHAR2(30);
1270: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1271: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1272: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1273: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1274: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;

Line 1271: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1267:
1268: l_mode VARCHAR2(30);
1269: l_action VARCHAR2(30);
1270: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1271: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1272: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1273: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1274: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1275: l_assignment_type pa_project_assignments.assignment_type%TYPE;

Line 1272: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1268: l_mode VARCHAR2(30);
1269: l_action VARCHAR2(30);
1270: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1271: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1272: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1273: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1274: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1275: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1276: l_status_code pa_project_assignments.status_code%TYPE;

Line 1344: l_monday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1340: l_change_rqmt_status_code VARCHAR2(30);
1341: l_change_asgmt_status_code VARCHAR2(30);
1342: l_change_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1343: l_change_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1344: l_monday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1345: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1346: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1347: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1348: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1345: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1341: l_change_asgmt_status_code VARCHAR2(30);
1342: l_change_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1343: l_change_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1344: l_monday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1345: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1346: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1347: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1348: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1349: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1346: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1342: l_change_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1343: l_change_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1344: l_monday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1345: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1346: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1347: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1348: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1349: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1350: l_sunday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1347: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1343: l_change_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1344: l_monday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1345: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1346: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1347: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1348: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1349: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1350: l_sunday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1351: l_num_of_sch_periods NUMBER;

Line 1348: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1344: l_monday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1345: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1346: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1347: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1348: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1349: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1350: l_sunday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1351: l_num_of_sch_periods NUMBER;
1352: l_non_working_day_flag VARCHAR2(1);

Line 1349: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1345: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1346: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1347: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1348: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1349: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1350: l_sunday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1351: l_num_of_sch_periods NUMBER;
1352: l_non_working_day_flag VARCHAR2(1);
1353: l_change_hours_type_code VARCHAR2(30);

Line 1350: l_sunday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1346: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1347: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1348: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1349: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1350: l_sunday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1351: l_num_of_sch_periods NUMBER;
1352: l_non_working_day_flag VARCHAR2(1);
1353: l_change_hours_type_code VARCHAR2(30);
1354: l_hrs_per_day NUMBER;

Line 1381: l_competence_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1377: l_number_of_competencies NUMBER;
1378: l_success_assignments_link VARCHAR2(2000);
1379: l_failure_assignments_link VARCHAR2(2000);
1380: l_assignment_duration NUMBER;
1381: l_competence_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1382: l_competence_alias_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1383: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1384: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_mandatory_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type() ;

Line 1384: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1380: l_assignment_duration NUMBER;
1381: l_competence_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1382: l_competence_alias_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1383: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1384: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_mandatory_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type() ;
1386: l_extension_possible_meaning fnd_lookups.meaning%TYPE;
1387: l_mandatory_flag_meaning fnd_lookups.meaning%TYPE;
1388: l_expense_owner_meaning pa_lookups.meaning%TYPE;

Line 2265: l_single_obj_id_tbl := SYSTEM.pa_num_tbl_type(l_object_id_tbl(i));

2261:
2262: -- Bug 2402193: reset the l_assignment_type
2263: l_assignment_type := l_wf_assignment_type;
2264: --store the object id being processed in l_single_obj_id_tbl
2265: l_single_obj_id_tbl := SYSTEM.pa_num_tbl_type(l_object_id_tbl(i));
2266:
2267: --call mass create assignments API if mode is mass asgmt
2268:
2269: IF l_mode = G_MASS_ASGMT THEN

Line 2576: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2572: IS
2573:
2574: l_mode VARCHAR2(30);
2575: l_action VARCHAR2(30);
2576: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2577: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2578: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2579: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2580: l_appr_over_auth_flag VARCHAR2(1);

Line 2577: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2573:
2574: l_mode VARCHAR2(30);
2575: l_action VARCHAR2(30);
2576: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2577: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2578: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2579: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2580: l_appr_over_auth_flag VARCHAR2(1);
2581: l_note_to_all_approvers VARCHAR2(2000);

Line 2586: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2582: l_conflict_group_id NUMBER;
2583: l_return_status VARCHAR2(1);
2584: l_msg_count NUMBER;
2585: l_msg_data fnd_new_messages.message_text%TYPE;
2586: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2587: l_document VARCHAR2(32767);
2588: l_project_id pa_projects_all.project_id%TYPE;
2589: l_submitter_user_id NUMBER;
2590: l_num_success_assignments NUMBER;