[Home] [Help]
6: FUNCTION get_seq_id RETURN NUMBER IS
7: l_seq NUMBER;
8: BEGIN
9: -- Changed by nikshah for SLA project (Bug 5707866) 16-Apr-2007
10: SELECT OKL_TRX_CONTRACTS_ALL_S.NEXTVAL INTO l_seq FROM DUAL;
11: RETURN l_seq;
12: END get_seq_id;
13:
14: ---------------------------------------------------------------------------
4927: INTO x_tcnv_rec.REQUEST_ID
4928: ,x_tcnv_rec.PROGRAM_APPLICATION_ID
4929: ,x_tcnv_rec.PROGRAM_ID
4930: ,x_tcnv_rec.PROGRAM_UPDATE_DATE
4931: FROM DUAL;
4932: -- Commented by zrehman for SLA project (Bug 5707866) 21-Feb-2007
4933: -- The derivation for the column is moved to OKL_TRX_CONTRACTS_PVT which in turn is
4934: -- used to derive representation_name and representation_code
4935: -- start
4942: BEGIN
4943:
4944: IF (x_tcnv_rec.trx_number IS NULL) OR
4945: (x_tcnv_rec.trx_number = OKL_API.G_MISS_CHAR) THEN
4946: SELECT OKL_TCN_SEQ.NEXTVAL INTO x_tcnv_rec.trx_number FROM DUAL;
4947: END IF;
4948:
4949: IF (x_tcnv_rec.currency_code IS NULL) OR
4950: (x_tcnv_rec.currency_code = OKL_API.G_MISS_CHAR) THEN
6504: INTO x_tcnv_rec.REQUEST_ID
6505: ,x_tcnv_rec.PROGRAM_APPLICATION_ID
6506: ,x_tcnv_rec.PROGRAM_ID
6507: ,x_tcnv_rec.PROGRAM_UPDATE_DATE
6508: FROM DUAL;
6509:
6510: RETURN(l_return_status);
6511: END Set_Attributes;
6512: BEGIN