[Home] [Help]
214: FND_MESSAGE.get_string('OZF','OZF_BATCH_STATUS_WNG'),
215: 'STATUS_CODE',
216: l_status_code,
217: l_org_id
218: FROM dual
219: WHERE NOT EXISTS (
220: SELECT 1
221: FROM ozf_resale_logs a
222: WHERE a.resale_id = p_resale_batch_id
3225: l_org_id NUMBER;
3226: -- Start: bug # 5997978 fixed
3227: /*CURSOR org_id_csr IS
3228: SELECT (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))
3229: FROM dual; */
3230: l_batch_org_id NUMBER;
3231: CURSOR org_id_csr(cv_resale_batch_id IN NUMBER) IS
3232: SELECT org_id
3233: FROM ozf_resale_batches_all
4709: l_obj_number NUMBER := 1.0;
4710:
4711: CURSOR resale_batch_id_csr IS
4712: SELECT ozf_resale_batches_all_s.nextval
4713: FROM dual;
4714: l_resale_batch_id NUMBER;
4715:
4716: CURSOR resale_batch_number_csr IS
4717: SELECT to_char(ozf_resale_batch_number_s.nextval)
4714: l_resale_batch_id NUMBER;
4715:
4716: CURSOR resale_batch_number_csr IS
4717: SELECT to_char(ozf_resale_batch_number_s.nextval)
4718: FROM dual;
4719: l_resale_batch_number VARCHAR2(30);
4720:
4721: CURSOR line_info_csr(p_id NUMBER,
4722: p_org_id NUMBER,
4909: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);
4910:
4911: -- Bug 14194884 - TPA In Draft Mode ER : Getting the Draft Run Id from the sequence. Draft Run Id will be incremented everytime TPA is run in DRAFT mode.
4912: IF l_run_mode = 'DRAFT' THEN
4913: SELECT OZF_DRAFT_RUN_S.nextval INTO l_draft_run_id FROM DUAL;
4914: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Draft Run Id : '|| l_draft_run_id);
4915: END IF;
4916:
4917: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');