APPS.PA_ALTERNATE_TASK_PVT dependencies on PA_VARCHAR2_1_TBL_TYPE

Line 70: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

66: X_Msg_Data OUT NOCOPY Varchar2,
67: X_Msg_Count OUT NOCOPY Number)
68: IS
69:
70: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
71: l_new_task_id PA_TASKS.TASK_ID%type;
72: l_count Number := -1;
73: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
74: l_attribute1 SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 256: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_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
256: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
257: BEGIN
258:
259:
260: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 309: X_Valid_Status OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE)

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';
313:

Line 311: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

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';
313:
314:
315: cursor isCostCodeAdded(c_Proj_Element_Id IN NUMBER, c_Cbs_Element_Id IN NUMBER) IS

Line 365: X_Valid_Status OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE

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
368: )
369: IS

Line 370: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

366: --x_error_code OUT NOCOPY NUMBER,
367: --x_error_msg_code OUT NOCOPY VARCHAR2
368: )
369: IS
370: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
371: L_TEMP VARCHAR2(1);
372: l_dummy number:=0;
373: l_project_id number;
374: Is_IEX_Installed BOOLEAN := False;

Line 1278: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1274: p_project_id IN NUMBER,
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