DBA Data[Home] [Help]

APPS.EAM_CREATEUPDATE_WO_PVT dependencies on EAM_PROCESS_SAFETY_PUB

Line 1552: l_eam_permit_tbl EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type;

1548: x_return_status OUT NOCOPY VARCHAR2,
1549: x_msg_count OUT NOCOPY NUMBER
1550: )
1551: IS
1552: l_eam_permit_tbl EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type;
1553: l_eam_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
1554: l_eam_work_clearance_tbl EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type;-- new parameter for safety clearance
1555: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
1556:

Line 1553: l_eam_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

1549: x_msg_count OUT NOCOPY NUMBER
1550: )
1551: IS
1552: l_eam_permit_tbl EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type;
1553: l_eam_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
1554: l_eam_work_clearance_tbl EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type;-- new parameter for safety clearance
1555: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
1556:
1557: BEGIN

Line 1554: l_eam_work_clearance_tbl EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type;-- new parameter for safety clearance

1550: )
1551: IS
1552: l_eam_permit_tbl EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type;
1553: l_eam_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
1554: l_eam_work_clearance_tbl EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type;-- new parameter for safety clearance
1555: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
1556:
1557: BEGIN
1558:

Line 1555: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;

1551: IS
1552: l_eam_permit_tbl EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type;
1553: l_eam_permit_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
1554: l_eam_work_clearance_tbl EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type;-- new parameter for safety clearance
1555: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
1556:
1557: BEGIN
1558:
1559:

Line 1735: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit

1731: p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type,
1732: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1733: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1734: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1735: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit
1736: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit
1737: p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ,-- new parameter for safety clearance
1738: p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type , --new parameter for safety clearance
1739: p_prev_activity_id IN NUMBER,

Line 1736: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit

1732: p_eam_counter_prop_tbl IN EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type,
1733: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1734: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1735: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit
1736: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit
1737: p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ,-- new parameter for safety clearance
1738: p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type , --new parameter for safety clearance
1739: p_prev_activity_id IN NUMBER,
1740: p_failure_id IN NUMBER := null,

Line 1737: p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ,-- new parameter for safety clearance

1733: p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type,
1734: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1735: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit
1736: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit
1737: p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ,-- new parameter for safety clearance
1738: p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type , --new parameter for safety clearance
1739: p_prev_activity_id IN NUMBER,
1740: p_failure_id IN NUMBER := null,
1741: p_failure_date IN DATE := null,

Line 1738: p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type , --new parameter for safety clearance

1734: p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type,
1735: p_eam_permit_tbl IN EAM_PROCESS_SAFETY_PUB.eam_wp_tbl_type, -- new param for safety permit
1736: p_eam_permit_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type, -- new param for safety permit
1737: p_eam_work_clearance_tbl IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_tbl_type ,-- new parameter for safety clearance
1738: p_eam_wc_wo_assoc_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type , --new parameter for safety clearance
1739: p_prev_activity_id IN NUMBER,
1740: p_failure_id IN NUMBER := null,
1741: p_failure_date IN DATE := null,
1742: p_failure_entry_id IN NUMBER := null,