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 4: pa_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

1: PACKAGE pa_mass_asgmt_trx AS
2: -- $Header: PARMATXS.pls 120.1 2005/08/29 20:51:10 sunkalya noship $
3:
4: pa_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5: pa_empty_varchar2_1_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
6: pa_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
7: pa_empty_varchar2_240_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
8:

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

24:
25: PROCEDURE start_mass_asgmt_trx_wf
26: (p_mode IN VARCHAR2
27: ,p_action IN VARCHAR2
28: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
29: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
30: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
31: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
32: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

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

25: PROCEDURE start_mass_asgmt_trx_wf
26: (p_mode IN VARCHAR2
27: ,p_action IN VARCHAR2
28: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
29: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
30: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
31: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
32: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

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

98: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
99: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
100: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
101: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
102: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
103: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
104: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
105: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
106: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

99: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
100: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
101: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
102: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
103: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
104: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
105: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
106: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
107: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

100: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
101: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
102: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
103: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
104: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
105: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
106: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
107: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
108: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

101: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
102: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
103: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
104: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
105: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
106: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
107: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
108: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
109: ,p_non_working_day_flag IN VARCHAR2 := 'N'

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

102: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
103: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
104: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
105: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
106: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
107: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
108: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
109: ,p_non_working_day_flag IN VARCHAR2 := 'N'
110: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

103: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
104: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
105: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
106: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
107: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
108: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
109: ,p_non_working_day_flag IN VARCHAR2 := 'N'
110: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM

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

104: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
105: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
106: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
107: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
108: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
109: ,p_non_working_day_flag IN VARCHAR2 := 'N'
110: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
112: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM

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

115: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
118: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
119: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
120: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
121: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
122: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
123: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

117: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
118: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
119: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
120: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
121: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
122: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
123: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
124: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
125: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

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

121: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
122: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
123: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
124: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
125: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
126: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
127: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
128: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
129: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := pa_empty_varchar2_1_tbl

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

124: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
125: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
126: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
127: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
128: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
129: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := pa_empty_varchar2_1_tbl
130: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
131: ,x_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
132: );

Line 147: p_resource_id_tbl IN SYSTEM.pa_num_tbl_type,

143: (p_item_type IN VARCHAR2,
144: p_item_key IN VARCHAR2,
145: p_actid IN NUMBER,
146: p_funcmode IN VARCHAR2,
147: p_resource_id_tbl IN SYSTEM.pa_num_tbl_type,
148: p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,
149: x_mode OUT NOCOPY VARCHAR2, --Bug: 4537865
150: x_action OUT NOCOPY VARCHAR2, --Bug: 4537865
151: x_start_date OUT NOCOPY DATE, --Bug: 4537865

Line 148: p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,

144: p_item_key IN VARCHAR2,
145: p_actid IN NUMBER,
146: p_funcmode IN VARCHAR2,
147: p_resource_id_tbl IN SYSTEM.pa_num_tbl_type,
148: p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,
149: x_mode OUT NOCOPY VARCHAR2, --Bug: 4537865
150: x_action OUT NOCOPY VARCHAR2, --Bug: 4537865
151: x_start_date OUT NOCOPY DATE, --Bug: 4537865
152: x_end_date OUT NOCOPY DATE, --Bug: 4537865