APPS.CSP_TO_FORM_MOLINES dependencies on CSP_MOVEORDER_LINES

Line 81: From csp_moveorder_lines

77: l_last_update_login NUMBER := p_last_updated_login;
78: l_last_updated_by NUMBER := p_last_updated_by;
79: Cursor l_Get_Creation_Date_Csr Is
80: Select creation_date
81: From csp_moveorder_lines
82: Where line_id = p_LINE_ID;
83: Cursor l_Get_Line_ID_Csr Is
84: Select line_id
85: From csp_moveorder_lines

Line 85: From csp_moveorder_lines

81: From csp_moveorder_lines
82: Where line_id = p_LINE_ID;
83: Cursor l_Get_Line_ID_Csr Is
84: Select line_id
85: From csp_moveorder_lines
86: Where line_id = p_LINE_ID;
87:
88: BEGIN
89: savepoint Validate_And_Write_PUB;

Line 299: FROM csp_moveorder_lines

295: RAISE EXCP_USER_DEFINED;
296: ELSE
297: BEGIN
298: SELECT line_id INTO l_check_existence
299: FROM csp_moveorder_lines
300: WHERE line_id = p_line_id;
301: EXCEPTION
302: WHEN NO_DATA_FOUND THEN
303: FND_MESSAGE.SET_NAME('CSP', 'CSP_MOLINE_NO_EXIST');

Line 334: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);

330: WHEN OTHERS THEN
331: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
332: fnd_message.set_token('ERR_FIELD', 'p_header_id', FALSE);
333: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
334: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
335: FND_MSG_PUB.ADD;
336: RAISE EXCP_USER_DEFINED;
337: END;
338: END IF;

Line 363: FROM csp_moveorder_lines

359: END;
360:
361: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
362: SELECT nvl(task_assignment_id, fnd_api.g_miss_num) INTO l_task_assignment_id
363: FROM csp_moveorder_lines
364: WHERE line_id = p_line_id;
365:
366: IF nvl(l_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
367: BEGIN

Line 395: FROM csp_moveorder_lines

391: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
392: IF nvl(p_task_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
393: -- find out the task_id in the existing moveorder_line record.
394: SELECT nvl(task_id, fnd_api.g_miss_num) INTO l_task_id
395: FROM csp_moveorder_lines
396: WHERE line_id = p_line_id;
397: END IF;
398:
399: IF nvl(l_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

Line 474: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);

470: Close l_Get_Creation_Date_Csr;
471: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
472: fnd_message.set_token('ERR_FIELD', 'p_cretaion_date', FALSE);
473: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
474: fnd_message.set_token('TABLE', 'CSP_MOVEORDER_LINES', FALSE);
475: FND_MSG_PUB.ADD;
476: RAISE EXCP_USER_DEFINED;
477: End if;
478: Close l_Get_Creation_Date_Csr;

Line 493: FROM csp_moveorder_lines

489: RAISE EXCP_USER_DEFINED;
490: ELSE
491: BEGIN
492: SELECT line_id INTO l_check_existence
493: FROM csp_moveorder_lines
494: WHERE line_id = p_line_id;
495: EXCEPTION
496: WHEN NO_DATA_FOUND THEN
497: FND_MESSAGE.SET_NAME('CSP', 'CSP_MOLINE_NO_EXIST');