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: ----Added following folloeing for bug 6199871 ------------------------

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

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

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

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

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

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

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

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

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

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

Line 1183: p_resource_id_tbl IN SYSTEM.pa_num_tbl_type,

1179: (p_item_type IN VARCHAR2,
1180: p_item_key IN VARCHAR2,
1181: p_actid IN NUMBER,
1182: p_funcmode IN VARCHAR2,
1183: p_resource_id_tbl IN SYSTEM.pa_num_tbl_type,
1184: p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,
1185: x_mode OUT NOCOPY VARCHAR2, -- 4537865
1186: x_action OUT NOCOPY VARCHAR2, -- 4537865
1187: x_start_date OUT NOCOPY DATE, -- 4537865

Line 1184: p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,

1180: p_item_key IN VARCHAR2,
1181: p_actid IN NUMBER,
1182: p_funcmode IN VARCHAR2,
1183: p_resource_id_tbl IN SYSTEM.pa_num_tbl_type,
1184: p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,
1185: x_mode OUT NOCOPY VARCHAR2, -- 4537865
1186: x_action OUT NOCOPY VARCHAR2, -- 4537865
1187: x_start_date OUT NOCOPY DATE, -- 4537865
1188: x_end_date OUT NOCOPY DATE, -- 4537865

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

1209: PRAGMA AUTONOMOUS_TRANSACTION;
1210:
1211: l_mode VARCHAR2(30);
1212: l_action VARCHAR2(30);
1213: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1214: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1215: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1216: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1217: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;

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

1210:
1211: l_mode VARCHAR2(30);
1212: l_action VARCHAR2(30);
1213: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1214: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1215: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1216: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1217: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1218: l_assignment_type pa_project_assignments.assignment_type%TYPE;

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

1211: l_mode VARCHAR2(30);
1212: l_action VARCHAR2(30);
1213: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1214: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1215: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1216: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1217: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1218: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1219: l_status_code pa_project_assignments.status_code%TYPE;

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

1283: l_change_rqmt_status_code VARCHAR2(30);
1284: l_change_asgmt_status_code VARCHAR2(30);
1285: l_change_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1286: l_change_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1287: l_monday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1288: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1289: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1290: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1291: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

1284: l_change_asgmt_status_code VARCHAR2(30);
1285: l_change_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1286: l_change_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1287: l_monday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1288: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1289: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1290: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1291: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1292: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

1285: l_change_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1286: l_change_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1287: l_monday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1288: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1289: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1290: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1291: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1292: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1293: l_sunday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

1286: l_change_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1287: l_monday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1288: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1289: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1290: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1291: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1292: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1293: l_sunday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1294: l_num_of_sch_periods NUMBER;

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

1287: l_monday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1288: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1289: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1290: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1291: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1292: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1293: l_sunday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1294: l_num_of_sch_periods NUMBER;
1295: l_non_working_day_flag VARCHAR2(1);

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

1288: l_tuesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1289: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1290: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1291: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1292: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1293: l_sunday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1294: l_num_of_sch_periods NUMBER;
1295: l_non_working_day_flag VARCHAR2(1);
1296: l_change_hours_type_code VARCHAR2(30);

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

1289: l_wednesday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1290: l_thursday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1291: l_friday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1292: l_saturday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1293: l_sunday_hours_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1294: l_num_of_sch_periods NUMBER;
1295: l_non_working_day_flag VARCHAR2(1);
1296: l_change_hours_type_code VARCHAR2(30);
1297: l_hrs_per_day NUMBER;

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

1320: l_number_of_competencies NUMBER;
1321: l_success_assignments_link VARCHAR2(2000);
1322: l_failure_assignments_link VARCHAR2(2000);
1323: l_assignment_duration NUMBER;
1324: l_competence_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1325: l_competence_alias_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1326: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1327: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1328: l_mandatory_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type() ;

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

1323: l_assignment_duration NUMBER;
1324: l_competence_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1325: l_competence_alias_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1326: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1327: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1328: l_mandatory_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type() ;
1329: l_extension_possible_meaning fnd_lookups.meaning%TYPE;
1330: l_mandatory_flag_meaning fnd_lookups.meaning%TYPE;
1331: l_expense_owner_meaning pa_lookups.meaning%TYPE;

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

2204:
2205: -- Bug 2402193: reset the l_assignment_type
2206: l_assignment_type := l_wf_assignment_type;
2207: --store the object id being processed in l_single_obj_id_tbl
2208: l_single_obj_id_tbl := SYSTEM.pa_num_tbl_type(l_object_id_tbl(i));
2209:
2210: --call mass create assignments API if mode is mass asgmt
2211:
2212: IF l_mode = G_MASS_ASGMT THEN

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

2515: IS
2516:
2517: l_mode VARCHAR2(30);
2518: l_action VARCHAR2(30);
2519: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2520: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2521: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2522: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2523: l_appr_over_auth_flag VARCHAR2(1);

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

2516:
2517: l_mode VARCHAR2(30);
2518: l_action VARCHAR2(30);
2519: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2520: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2521: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2522: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2523: l_appr_over_auth_flag VARCHAR2(1);
2524: l_note_to_all_approvers VARCHAR2(2000);

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

2525: l_conflict_group_id NUMBER;
2526: l_return_status VARCHAR2(1);
2527: l_msg_count NUMBER;
2528: l_msg_data fnd_new_messages.message_text%TYPE;
2529: l_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2530: l_document VARCHAR2(32767);
2531: l_project_id pa_projects_all.project_id%TYPE;
2532: l_submitter_user_id NUMBER;
2533: l_num_success_assignments NUMBER;