APPS.GMD_OPERATION_ACTIVITIES_PUB dependencies on GMD_OPERATIONS

Line 56: , p_oprn_no IN gmd_operations.oprn_no%TYPE

52: PROCEDURE insert_operation_activity
53: ( p_api_version IN NUMBER
54: , p_init_msg_list IN BOOLEAN
55: , p_commit IN BOOLEAN
56: , p_oprn_no IN gmd_operations.oprn_no%TYPE
57: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
58: , p_oprn_activity IN OUT NOCOPY gmd_operation_activities%ROWTYPE
59: , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type
60: , x_message_count OUT NOCOPY NUMBER

Line 57: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE

53: ( p_api_version IN NUMBER
54: , p_init_msg_list IN BOOLEAN
55: , p_commit IN BOOLEAN
56: , p_oprn_no IN gmd_operations.oprn_no%TYPE
57: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE
58: , p_oprn_activity IN OUT NOCOPY gmd_operation_activities%ROWTYPE
59: , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type
60: , x_message_count OUT NOCOPY NUMBER
61: , x_message_list OUT NOCOPY VARCHAR2

Line 76: CURSOR check_oprn_id (p_oprn_id gmd_operations.oprn_id%TYPE)IS

72: setup_failure EXCEPTION;
73: invalid_version EXCEPTION;
74: ins_oprn_actv_err EXCEPTION;
75:
76: CURSOR check_oprn_id (p_oprn_id gmd_operations.oprn_id%TYPE)IS
77: SELECT 1
78: FROM gmd_operations_b
79: WHERE oprn_id = p_oprn_id
80: AND delete_mark = 0;

Line 78: FROM gmd_operations_b

74: ins_oprn_actv_err EXCEPTION;
75:
76: CURSOR check_oprn_id (p_oprn_id gmd_operations.oprn_id%TYPE)IS
77: SELECT 1
78: FROM gmd_operations_b
79: WHERE oprn_id = p_oprn_id
80: AND delete_mark = 0;
81:
82: CURSOR check_oprn_no_vers(p_oprn_no gmd_operations.oprn_no%TYPE

Line 82: CURSOR check_oprn_no_vers(p_oprn_no gmd_operations.oprn_no%TYPE

78: FROM gmd_operations_b
79: WHERE oprn_id = p_oprn_id
80: AND delete_mark = 0;
81:
82: CURSOR check_oprn_no_vers(p_oprn_no gmd_operations.oprn_no%TYPE
83: , p_oprn_vers gmd_operations.oprn_vers%TYPE ) IS
84: SELECT oprn_id
85: FROM gmd_operations_b
86: WHERE oprn_No = p_oprn_no

Line 83: , p_oprn_vers gmd_operations.oprn_vers%TYPE ) IS

79: WHERE oprn_id = p_oprn_id
80: AND delete_mark = 0;
81:
82: CURSOR check_oprn_no_vers(p_oprn_no gmd_operations.oprn_no%TYPE
83: , p_oprn_vers gmd_operations.oprn_vers%TYPE ) IS
84: SELECT oprn_id
85: FROM gmd_operations_b
86: WHERE oprn_No = p_oprn_no
87: AND oprn_vers = p_oprn_vers

Line 85: FROM gmd_operations_b

81:
82: CURSOR check_oprn_no_vers(p_oprn_no gmd_operations.oprn_no%TYPE
83: , p_oprn_vers gmd_operations.oprn_vers%TYPE ) IS
84: SELECT oprn_id
85: FROM gmd_operations_b
86: WHERE oprn_No = p_oprn_no
87: AND oprn_vers = p_oprn_vers
88: and delete_Mark = 0;
89:

Line 296: v_oprn_id gmd_operations.oprn_id%TYPE;

292: , x_message_count OUT NOCOPY NUMBER
293: , x_message_list OUT NOCOPY VARCHAR2
294: , x_return_status OUT NOCOPY VARCHAR2) IS
295:
296: v_oprn_id gmd_operations.oprn_id%TYPE;
297: l_retn_status VARCHAR2(1);
298: l_api_version NUMBER := 1.0;
299:
300: invalid_version EXCEPTION;