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_PROJECT_DATES_UTILS dependencies on PA_VARCHAR2_2000_TBL_TYPE

Line 1181: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,

1177: PROCEDURE VALIDATE_ASSIGNMENT_DATES_BULK
1178: (p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1179: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1180: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1181: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1182: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1183: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1184: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE)
1185:

Line 1182: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,

1178: (p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1179: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1180: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1181: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1182: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1183: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1184: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE)
1185:
1186: IS

Line 1183: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,

1179: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1180: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1181: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1182: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1183: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1184: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE)
1185:
1186: IS
1187: l_prj_min_date DATE;

Line 1184: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE)

1180: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1181: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1182: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1183: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1184: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE)
1185:
1186: IS
1187: l_prj_min_date DATE;
1188: l_prj_max_date DATE;

Line 1199: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;

1195: FROM pa_projects_all
1196: WHERE project_id = l_proj_id ;
1197:
1198: l_validate VARCHAR2 (2000);
1199: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1200: l_start_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1201: l_end_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1202: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1203:

Line 1200: l_start_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;

1196: WHERE project_id = l_proj_id ;
1197:
1198: l_validate VARCHAR2 (2000);
1199: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1200: l_start_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1201: l_end_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1202: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1203:
1204: l_valid_assign_start_flag VARCHAR2(1) := 'Y';

Line 1201: l_end_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;

1197:
1198: l_validate VARCHAR2 (2000);
1199: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1200: l_start_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1201: l_end_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1202: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1203:
1204: l_valid_assign_start_flag VARCHAR2(1) := 'Y';
1205:

Line 1202: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;

1198: l_validate VARCHAR2 (2000);
1199: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1200: l_start_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1201: l_end_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1202: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1203:
1204: l_valid_assign_start_flag VARCHAR2(1) := 'Y';
1205:
1206: BEGIN

Line 1335: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,

1331: PROCEDURE Validate_Resource_Dates_Bulk
1332: (p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1333: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1334: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1335: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1336: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1337: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1338: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE)
1339:

Line 1336: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,

1332: (p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1333: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1334: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1335: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1336: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1337: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1338: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE)
1339:
1340: IS

Line 1337: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,

1333: p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1334: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1335: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1336: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1337: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1338: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE)
1339:
1340: IS
1341: l_prj_min_date DATE;

Line 1338: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE)

1334: p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
1335: x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1336: x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1337: x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
1338: x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE)
1339:
1340: IS
1341: l_prj_min_date DATE;
1342: l_prj_max_date DATE;

Line 1353: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;

1349: FROM pa_projects_all
1350: WHERE project_id = l_proj_id ;
1351:
1352: l_validate varchar2(2000);
1353: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1354: l_start_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1355: l_end_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1356: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1357:

Line 1354: l_start_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;

1350: WHERE project_id = l_proj_id ;
1351:
1352: l_validate varchar2(2000);
1353: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1354: l_start_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1355: l_end_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1356: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1357:
1358: l_valid_assign_start_flag VARCHAR2(1) := 'Y';

Line 1355: l_end_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;

1351:
1352: l_validate varchar2(2000);
1353: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1354: l_start_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1355: l_end_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1356: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1357:
1358: l_valid_assign_start_flag VARCHAR2(1) := 'Y';
1359:

Line 1356: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;

1352: l_validate varchar2(2000);
1353: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1354: l_start_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1355: l_end_date_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1356: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;
1357:
1358: l_valid_assign_start_flag VARCHAR2(1) := 'Y';
1359:
1360: BEGIN