eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BCT_PVT dependencies on OKL_BOOK_CONTROLLER_TRX

Line 23: -- Procedure get_rec for OKL_BOOK_CONTROLLER_TRX

19: null;
20: END change_version;
21:
22: --------------------------------------------------------------------------------
23: -- Procedure get_rec for OKL_BOOK_CONTROLLER_TRX
24: --------------------------------------------------------------------------------
25: FUNCTION get_rec(
26: p_bct_rec IN okl_bct_rec,
27: x_no_data_found OUT NOCOPY BOOLEAN

Line 47: FROM OKL_BOOK_CONTROLLER_TRX

43: LAST_UPDATED_BY,
44: LAST_UPDATE_DATE,
45: LAST_UPDATE_LOGIN,
46: ACTIVE_FLAG
47: FROM OKL_BOOK_CONTROLLER_TRX
48: WHERE OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER = p_batch_number
49: AND OKL_BOOK_CONTROLLER_TRX.PROCESSING_SRL_NUMBER = p_srl_number;
50: l_bct_pk bct_pk_csr%ROWTYPE;
51: l_bct_rec okl_bct_rec;

Line 48: WHERE OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER = p_batch_number

44: LAST_UPDATE_DATE,
45: LAST_UPDATE_LOGIN,
46: ACTIVE_FLAG
47: FROM OKL_BOOK_CONTROLLER_TRX
48: WHERE OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER = p_batch_number
49: AND OKL_BOOK_CONTROLLER_TRX.PROCESSING_SRL_NUMBER = p_srl_number;
50: l_bct_pk bct_pk_csr%ROWTYPE;
51: l_bct_rec okl_bct_rec;
52: BEGIN

Line 49: AND OKL_BOOK_CONTROLLER_TRX.PROCESSING_SRL_NUMBER = p_srl_number;

45: LAST_UPDATE_LOGIN,
46: ACTIVE_FLAG
47: FROM OKL_BOOK_CONTROLLER_TRX
48: WHERE OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER = p_batch_number
49: AND OKL_BOOK_CONTROLLER_TRX.PROCESSING_SRL_NUMBER = p_srl_number;
50: l_bct_pk bct_pk_csr%ROWTYPE;
51: l_bct_rec okl_bct_rec;
52: BEGIN
53: x_no_data_found:= TRUE;

Line 87: -- FUNCTION null_out_defaults for: OKL_BOOK_CONTROLLER_TRX

83: RETURN(get_rec(p_bct_rec,l_row_notfound));
84: END get_rec;
85:
86: ---------------------------------------------------------------------------
87: -- FUNCTION null_out_defaults for: OKL_BOOK_CONTROLLER_TRX
88: ---------------------------------------------------------------------------
89: FUNCTION null_out_defaults(
90: p_bct_rec IN okl_bct_rec
91: )RETURN okl_bct_rec IS

Line 587: -- Validate_Attributes for:OKL_BOOK_CONTROLLER_TRX --

583: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
584: END validate_progress_status;
585:
586: -----------------------------------------------------------------
587: -- Validate_Attributes for:OKL_BOOK_CONTROLLER_TRX --
588: -----------------------------------------------------------------
589: FUNCTION Validate_Attributes (
590: p_bct_rec IN okl_bct_rec
591: )RETURN VARCHAR2 IS

Line 680: -- Validate Record for:OKL_BOOK_CONTROLLER_TRX --

676:
677: RETURN (x_return_status);
678: END Validate_Attributes;
679: ------------------------------------------------------
680: -- Validate Record for:OKL_BOOK_CONTROLLER_TRX --
681: ------------------------------------------------------
682: FUNCTION Validate_Record (
683: p_bct_rec IN okl_bct_rec
684: )RETURN VARCHAR2 IS

Line 691: -- Procedure insert_row for:OKL_BOOK_CONTROLLER_TRX --

687: BEGIN
688: RETURN (x_return_status);
689: END Validate_Record;
690: --------------------------------------------------------------------------------
691: -- Procedure insert_row for:OKL_BOOK_CONTROLLER_TRX --
692: --------------------------------------------------------------------------------
693: PROCEDURE insert_row(
694: p_api_version IN NUMBER ,
695: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 772: INSERT INTO OKL_BOOK_CONTROLLER_TRX(

768: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
769: RAISE OKL_API.G_EXCEPTION_ERROR;
770: END IF;
771:
772: INSERT INTO OKL_BOOK_CONTROLLER_TRX(
773: USER_ID,
774: ORG_ID,
775: BATCH_NUMBER,
776: PROCESSING_SRL_NUMBER,

Line 842: -- Procedure insert_row with PL/SQL table for:OKL_BOOK_CONTROLLER_TRX --

838: x_msg_data,
839: '_PVT');
840: END insert_row;
841: --------------------------------------------------------------------------------
842: -- Procedure insert_row with PL/SQL table for:OKL_BOOK_CONTROLLER_TRX --
843: --------------------------------------------------------------------------------
844: PROCEDURE insert_row(
845: p_api_version IN NUMBER ,
846: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 917: -- Procedure update_row for:OKL_BOOK_CONTROLLER_TRX --

913: x_msg_data,
914: '_PVT');
915: END insert_row;
916: --------------------------------------------------------------------------------
917: -- Procedure update_row for:OKL_BOOK_CONTROLLER_TRX --
918: --------------------------------------------------------------------------------
919: PROCEDURE update_row(
920: p_api_version IN NUMBER ,
921: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1066: UPDATE OKL_BOOK_CONTROLLER_TRX

1062: RAISE OKL_API.G_EXCEPTION_ERROR;
1063: END IF;
1064:
1065:
1066: UPDATE OKL_BOOK_CONTROLLER_TRX
1067: SET
1068: USER_ID= l_def_bct_rec.USER_ID,
1069: ORG_ID= l_def_bct_rec.ORG_ID,
1070: BATCH_NUMBER= l_def_bct_rec.BATCH_NUMBER,

Line 1123: -- Procedure update_row with PL/SQL table for:OKL_BOOK_CONTROLLER_TRX --

1119: x_msg_data,
1120: '_PVT');
1121: END update_row;
1122: --------------------------------------------------------------------------------
1123: -- Procedure update_row with PL/SQL table for:OKL_BOOK_CONTROLLER_TRX --
1124: --------------------------------------------------------------------------------
1125: PROCEDURE update_row(
1126: p_api_version IN NUMBER ,
1127: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1197: -- Procedure delete_row for:OKL_BOOK_CONTROLLER_TRX --

1193: x_msg_data,
1194: '_PVT');
1195: END update_row;
1196: --------------------------------------------------------------------------------
1197: -- Procedure delete_row for:OKL_BOOK_CONTROLLER_TRX --
1198: --------------------------------------------------------------------------------
1199: PROCEDURE delete_row(
1200: p_api_version IN NUMBER ,
1201: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1228: DELETE FROM OKL_BOOK_CONTROLLER_TRX

1224: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1225: RAISE OKL_API.G_EXCEPTION_ERROR;
1226: END IF;
1227:
1228: DELETE FROM OKL_BOOK_CONTROLLER_TRX
1229: WHERE BATCH_NUMBER=l_bct_rec.batch_number
1230: AND PROCESSING_SRL_NUMBER = l_bct_rec.processing_srl_number;
1231:
1232: EXCEPTION

Line 1265: -- Procedure delete_row with PL/SQL table for:OKL_BOOK_CONTROLLER_TRX --

1261: x_msg_data,
1262: '_PVT');
1263: END delete_row;
1264: --------------------------------------------------------------------------------
1265: -- Procedure delete_row with PL/SQL table for:OKL_BOOK_CONTROLLER_TRX --
1266: --------------------------------------------------------------------------------
1267: PROCEDURE delete_row(
1268: p_api_version IN NUMBER ,
1269: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,