DBA Data[Home] [Help]

APPS.GMD_OPERATION_RESOURCES_PVT dependencies on GMD_OPERATION_ACTIVITIES

Line 57: (p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE

53: This particular procedure is used to insert an operation resources
54: Parameters
55: ================================================ */
56: PROCEDURE insert_operation_resources
57: (p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
58: , p_oprn_rsrc_tbl IN GMD_OPERATION_RESOURCES_PUB.gmd_oprn_resources_tbl_type
59: , x_message_count OUT NOCOPY NUMBER
60: , x_message_list OUT NOCOPY VARCHAR2
61: , x_return_status OUT NOCOPY VARCHAR2) IS

Line 65: FROM gmd_operation_resources a, gmd_operation_activities b

61: , x_return_status OUT NOCOPY VARCHAR2) IS
62:
63: CURSOR Cur_check_resource (V_oprn_line_id NUMBER, V_resources VARCHAR2) IS
64: SELECT activity
65: FROM gmd_operation_resources a, gmd_operation_activities b
66: WHERE a.oprn_line_id = V_oprn_line_id
67: AND resources = V_resources
68: AND a.oprn_line_id = b.oprn_line_id;
69: