DBA Data[Home] [Help]

APPS.CSD_RECALLS_PVT dependencies on CSD_RECALL_LINES_GROUP_S1

Line 530: SELECT csd_recall_lines_group_s1.NEXTVAL INTO l_group_id FROM dual;

526: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
527: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Update the recall lines as processing');
528: END IF;
529:
530: SELECT csd_recall_lines_group_s1.NEXTVAL INTO l_group_id FROM dual;
531:
532: -- update the selected recall line id's as processing flag = 'Y';
533: UPDATE CSD_RECALL_LINES crl SET processing_flag = 'Y', processing_group_id = l_group_id
534: WHERE crl.recall_line_id IN (SELECT * FROM TABLE(CAST(p_recall_line_ids as JTF_NUMBER_TABLE)))