DBA Data[Home] [Help]

APPS.CSF_PLANBOARD_TASKS dependencies on CSF_RESOURCE

Line 261: v_restab csf_resource_tbl := csf_resource_tbl();

257: INDEX BY BINARY_INTEGER;
258:
259: g_parts_tbl parts_tbl ;
260:
261: v_restab csf_resource_tbl := csf_resource_tbl();
262:
263: -- cursors
264: ----------
265: --dependency check

Line 391: FROM Table(Cast(v_restab As csf_resource_tbl))

387: , cs.availability_type
388: FROM ( SELECT resource_id,
389: resource_type,
390: resource_name
391: FROM Table(Cast(v_restab As csf_resource_tbl))
392: ) res
393: , jtf_task_assignments a
394: , jtf_tasks_b t
395: , jtf_task_statuses_vl ts1

Line 465: FROM Table(Cast(v_restab As csf_resource_tbl))

461: , cs.availability_type
462: FROM ( SELECT resource_id,
463: resource_type,
464: resource_name
465: FROM Table(Cast(v_restab As csf_resource_tbl))
466: ) res
467: , jtf_task_assignments a
468: , jtf_tasks_b t
469: , jtf_task_statuses_vl ts1

Line 530: FROM Table(Cast(v_restab As csf_resource_tbl))

526: ,csr.availability_type
527: FROM ( SELECT resource_id,
528: resource_type,
529: resource_name
530: FROM Table(Cast(v_restab As csf_resource_tbl))
531: ) res
532: , jtf_task_assignments a
533: , jtf_tasks_b t
534: , jtf_task_statuses_vl ts1

Line 808: v_restab(v_restab.Last) := csf_resource(null,null,null,resource_id(i), resource_type(i), resource_name(i),null,null);

804:
805: FOR i IN 1 .. resource_id.COUNT LOOP
806: k := k + 1;
807: v_restab.extend;
808: v_restab(v_restab.Last) := csf_resource(null,null,null,resource_id(i), resource_type(i), resource_name(i),null,null);
809: l_pr.resource_id := resource_id(i);
810: l_pr.resource_type := resource_type(i);
811: l_pr.resource_name := resource_name(i);
812: x_pb_tbl(k) := l_pr;