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

Line 47: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

43: * with the unique combination of Proj element and Cost code.
44: *
45: */
46: Procedure Create_Alt_Task(
47: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
48: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
49: p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
50: p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE(),
51: p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE(),

Line 48: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

44: *
45: */
46: Procedure Create_Alt_Task(
47: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
48: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
49: p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
50: p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE(),
51: p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE(),
52: p_attribute3 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE(),

Line 251: p_Alt_Task_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

247: * In this it needs to validate whether the alternate task can be deleted or not.
248: *
249: */
250: PROCEDURE Delete_Alt_Task(
251: p_Alt_Task_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
252: X_Return_Status OUT NOCOPY Varchar2,
253: X_Msg_Data OUT NOCOPY Varchar2,
254: X_Msg_Count OUT NOCOPY Number)
255: IS

Line 307: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

303: * existing for the given proj element and the cost code.
304: *
305: */
306: Procedure Validate_Alt_Tasks_Gen(
307: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
308: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
309: X_Valid_Status OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE)
310: IS
311: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 308: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

304: *
305: */
306: Procedure Validate_Alt_Tasks_Gen(
307: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
308: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
309: X_Valid_Status OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE)
310: IS
311: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
312: L_TEMP VARCHAR2(1) := 'N';

Line 363: p_Alt_Task_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

359: * eligible for deletion or not.
360: *
361: */
362: Procedure Validate_Del_Alt_Tasks(
363: p_Alt_Task_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
364: p_context IN VARCHAR2 := 'COST_CODE',
365: X_Valid_Status OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE
366: --x_error_code OUT NOCOPY NUMBER,
367: --x_error_msg_code OUT NOCOPY VARCHAR2

Line 830: l_Proj_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();

826: X_Msg_Data OUT NOCOPY Varchar2,
827: X_Msg_Count OUT NOCOPY Number)
828: IS
829:
830: l_Proj_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
831: l_Cbs_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
832: L_TEMP VARCHAR2(1);
833:
834: cursor getCostCodes(c_Task_Id IN NUMBER) IS

Line 831: l_Cbs_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();

827: X_Msg_Count OUT NOCOPY Number)
828: IS
829:
830: l_Proj_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
831: l_Cbs_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
832: L_TEMP VARCHAR2(1);
833:
834: cursor getCostCodes(c_Task_Id IN NUMBER) IS
835: select CBS_ELEMENT_ID from PA_ALTERNATE_TASKS

Line 1279: l_Alt_Task_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();

1275: X_Return_Status OUT NOCOPY Varchar2,
1276: X_Msg_Data OUT NOCOPY Varchar2)
1277: IS
1278: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1279: l_Alt_Task_Id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.PA_NUM_TBL_TYPE();
1280: X_Msg_Count Number;
1281:
1282: BEGIN
1283:

Line 1326: l_Source_Proj_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();

1322: X_Msg_Data OUT NOCOPY Varchar2,
1323: X_Msg_Count OUT NOCOPY Number)
1324: IS
1325:
1326: l_Source_Proj_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
1327: l_Target_Proj_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
1328:
1329: Cursor C_GET_PROJECT_ELEMENTS IS
1330: Select distinct PPE1.Proj_element_id Source_Task_Id, PPE2.Proj_element_id Target_Task_Id

Line 1327: l_Target_Proj_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();

1323: X_Msg_Count OUT NOCOPY Number)
1324: IS
1325:
1326: l_Source_Proj_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
1327: l_Target_Proj_Element_Id SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
1328:
1329: Cursor C_GET_PROJECT_ELEMENTS IS
1330: Select distinct PPE1.Proj_element_id Source_Task_Id, PPE2.Proj_element_id Target_Task_Id
1331: From PA_PROJ_ELEMENTS PPE1, PA_PROJ_ELEMENTS PPE2