8: G_XPRT_ENTITY VARCHAR2(240) := 'XPRT';
9: G_DLVBL_ENTITY VARCHAR2(240) := 'DELIVERABLE';
10: ---------------------------------------------------------------------
11: PROCEDURE lock_entity( P_API_VERSION IN NUMBER,
12: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
13: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
14: -----------------
15: P_ENTITY_NAME IN VARCHAR2,
16: P_ENTITY_PK1 IN VARCHAR2,
9: G_DLVBL_ENTITY VARCHAR2(240) := 'DELIVERABLE';
10: ---------------------------------------------------------------------
11: PROCEDURE lock_entity( P_API_VERSION IN NUMBER,
12: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
13: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
14: -----------------
15: P_ENTITY_NAME IN VARCHAR2,
16: P_ENTITY_PK1 IN VARCHAR2,
17: P_ENTITY_PK2 IN VARCHAR2 DEFAULT NULL,
27: X_MSG_DATA OUT NOCOPY VARCHAR2
28: );
29: /* This procedure is no longer used - instead use rebuild_ids*/
30: PROCEDURE rebuild_locks( p_api_version IN NUMBER,
31: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
32: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
33: p_update_from_doc_type IN VARCHAR2,
34: p_update_from_doc_id IN NUMBER,
35: p_update_to_doc_type IN VARCHAR2,
28: );
29: /* This procedure is no longer used - instead use rebuild_ids*/
30: PROCEDURE rebuild_locks( p_api_version IN NUMBER,
31: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
32: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
33: p_update_from_doc_type IN VARCHAR2,
34: p_update_from_doc_id IN NUMBER,
35: p_update_to_doc_type IN VARCHAR2,
36: p_update_to_doc_id IN NUMBER,
39: X_MSG_DATA OUT NOCOPY VARCHAR2
40: );
41:
42: PROCEDURE release_locks (p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45: p_doc_type IN VARCHAR2,
46: p_doc_id IN NUMBER,
47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
40: );
41:
42: PROCEDURE release_locks (p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45: p_doc_type IN VARCHAR2,
46: p_doc_id IN NUMBER,
47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
48: X_MSG_COUNT OUT NOCOPY NUMBER,
51:
52: PROCEDURE unlock_entity (
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2
55: DEFAULT fnd_api.g_false,
56: p_commit IN VARCHAR2
57: DEFAULT fnd_api.g_false,
58: p_entity_name IN VARCHAR2,
59: p_entity_pk1 IN VARCHAR2,
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2
55: DEFAULT fnd_api.g_false,
56: p_commit IN VARCHAR2
57: DEFAULT fnd_api.g_false,
58: p_entity_name IN VARCHAR2,
59: p_entity_pk1 IN VARCHAR2,
60: p_entity_pk2 IN VARCHAR2 DEFAULT NULL,
61: p_entity_pk3 IN VARCHAR2 DEFAULT NULL,
69: x_msg_data OUT NOCOPY VARCHAR2
70: );
71:
72: PROCEDURE revert_changes( p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75: p_K_ENTITY_LOCK_ID IN NUMBER,
76: P_ENTITY_NAME IN VARCHAR2,
77: P_ENTITY_PK1 IN VARCHAR2,
70: );
71:
72: PROCEDURE revert_changes( p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75: p_K_ENTITY_LOCK_ID IN NUMBER,
76: P_ENTITY_NAME IN VARCHAR2,
77: P_ENTITY_PK1 IN VARCHAR2,
78: P_ENTITY_PK2 IN VARCHAR2 DEFAULT NULL,
88: );
89:
90:
91: PROCEDURE revert_entity ( p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
94: p_k_entity_lock_id IN NUMBER,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96: X_MSG_COUNT OUT NOCOPY NUMBER,
89:
90:
91: PROCEDURE revert_entity ( p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
94: p_k_entity_lock_id IN NUMBER,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96: X_MSG_COUNT OUT NOCOPY NUMBER,
97: X_MSG_DATA OUT NOCOPY VARCHAR2
177: p_action_req_details IN VARCHAR2,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
182: );
183:
184: PROCEDURE rebuild_ids( p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
182: );
183:
184: PROCEDURE rebuild_ids( p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
187: p_update_from_doc_type IN VARCHAR2, -- Mod document
188: p_update_from_doc_id IN NUMBER, -- Mod document
189: p_update_to_doc_type IN VARCHAR2, -- Award document
182: );
183:
184: PROCEDURE rebuild_ids( p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
187: p_update_from_doc_type IN VARCHAR2, -- Mod document
188: p_update_from_doc_id IN NUMBER, -- Mod document
189: p_update_to_doc_type IN VARCHAR2, -- Award document
190: p_update_to_doc_id IN NUMBER, -- Award document
222: *
223: **/
224: PROCEDURE merge_changes (
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
227: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
228: p_src_doc_type IN VARCHAR2, -- PAR document
229: p_src_doc_id IN NUMBER, -- PAR document
230: p_target_doc_type IN VARCHAR2, -- MOD document
223: **/
224: PROCEDURE merge_changes (
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
227: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
228: p_src_doc_type IN VARCHAR2, -- PAR document
229: p_src_doc_id IN NUMBER, -- PAR document
230: p_target_doc_type IN VARCHAR2, -- MOD document
231: p_target_doc_id IN NUMBER, -- MOD document