APPS.OKL_TXL_ITM_INSTS_PVT dependencies on OKL_ITI_PVT

Line 119: OKL_ITI_PVT.insert_row(p_api_version,

115: RAISE OKC_API.G_EXCEPTION_ERROR;
116: END IF;
117: -- evaluate conditions, build outcomes for true conditions and
118: -- put them on outcome queue
119: OKL_ITI_PVT.insert_row(p_api_version,
120: p_init_msg_list,
121: x_return_status,
122: x_msg_count,
123: x_msg_data,

Line 211: OKL_ITI_PVT.insert_row(p_api_version,

207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;
209: -- evaluate conditions, build outcomes for true conditions and
210: -- put them on outcome queue
211: OKL_ITI_PVT.insert_row(p_api_version,
212: p_init_msg_list,
213: x_return_status,
214: x_msg_count,
215: x_msg_data,

Line 273: OKL_ITI_PVT.lock_row(p_api_version,

269: RAISE OKC_API.G_EXCEPTION_ERROR;
270: END IF;
271: -- evaluate conditions, build outcomes for true conditions and
272: -- put them on outcome queue
273: OKL_ITI_PVT.lock_row(p_api_version,
274: p_init_msg_list,
275: x_return_status,
276: x_msg_count,
277: x_msg_data,

Line 332: OKL_ITI_PVT.lock_row(p_api_version,

328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;
330: -- evaluate conditions, build outcomes for true conditions and
331: -- put them on outcome queue
332: OKL_ITI_PVT.lock_row(p_api_version,
333: p_init_msg_list,
334: x_return_status,
335: x_msg_count,
336: x_msg_data,

Line 418: OKL_ITI_PVT.update_row(p_api_version,

414: CLOSE get_serial_num;
415: --vthiruva..09-Dec-2004..Added code to enable Business Events..END
416: -- evaluate conditions, build outcomes for true conditions and
417: -- put them on outcome queue
418: OKL_ITI_PVT.update_row(p_api_version,
419: p_init_msg_list,
420: x_return_status,
421: x_msg_count,
422: x_msg_data,

Line 551: OKL_ITI_PVT.update_row(p_api_version,

547: RAISE OKC_API.G_EXCEPTION_ERROR;
548: END IF;
549: -- evaluate conditions, build outcomes for true conditions and
550: -- put them on outcome queue
551: OKL_ITI_PVT.update_row(p_api_version,
552: p_init_msg_list,
553: x_return_status,
554: x_msg_count,
555: x_msg_data,

Line 648: OKL_ITI_PVT.delete_row(p_api_version,

644: *
645: */
646: -- evaluate conditions, build outcomes for true conditions and
647: -- put them on outcome queue
648: OKL_ITI_PVT.delete_row(p_api_version,
649: p_init_msg_list,
650: x_return_status,
651: x_msg_count,
652: x_msg_data,

Line 764: OKL_ITI_PVT.delete_row(p_api_version,

760: RAISE OKC_API.G_EXCEPTION_ERROR;
761: END IF;
762: -- evaluate conditions, build outcomes for true conditions and
763: -- put them on outcome queue
764: OKL_ITI_PVT.delete_row(p_api_version,
765: p_init_msg_list,
766: x_return_status,
767: x_msg_count,
768: x_msg_data,

Line 823: OKL_ITI_PVT.validate_row(p_api_version,

819: RAISE OKC_API.G_EXCEPTION_ERROR;
820: END IF;
821: -- evaluate conditions, build outcomes for true conditions and
822: -- put them on outcome queue
823: OKL_ITI_PVT.validate_row(p_api_version,
824: p_init_msg_list,
825: x_return_status,
826: x_msg_count,
827: x_msg_data,

Line 882: OKL_ITI_PVT.validate_row(p_api_version,

878: RAISE OKC_API.G_EXCEPTION_ERROR;
879: END IF;
880: -- evaluate conditions, build outcomes for true conditions and
881: -- put them on outcome queue
882: OKL_ITI_PVT.validate_row(p_api_version,
883: p_init_msg_list,
884: x_return_status,
885: x_msg_count,
886: x_msg_data,

Line 1010: l_iti_rec okl_iti_pvt.iti_rec_type;

1006:
1007: l_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1008: x_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1009:
1010: l_iti_rec okl_iti_pvt.iti_rec_type;
1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1012: x_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1013:
1014: l_itiv_rec okl_iti_pvt.itiv_rec_type;

Line 1014: l_itiv_rec okl_iti_pvt.itiv_rec_type;

1010: l_iti_rec okl_iti_pvt.iti_rec_type;
1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1012: x_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1013:
1014: l_itiv_rec okl_iti_pvt.itiv_rec_type;
1015:
1016: x_no_data_found BOOLEAN;
1017:
1018: l_chr_valid VARCHAR2(1);

Line 1028: ) RETURN okl_iti_pvt.itiv_rec_type IS

1024:
1025: FUNCTION get_rec (
1026: p_id IN NUMBER,
1027: x_no_data_found OUT NOCOPY BOOLEAN
1028: ) RETURN okl_iti_pvt.itiv_rec_type IS
1029: CURSOR okl_itiv_pk_csr (p_id IN NUMBER) IS
1030: SELECT ID,
1031: OBJECT_VERSION_NUMBER,
1032: TAS_ID,

Line 1077: l_itiv_rec okl_iti_pvt.itiv_rec_type;

1073: asd_id
1074: FROM OKL_TXL_ITM_INSTS_V iti
1075: WHERE iti.kle_id = p_id;
1076: l_okl_itiv_pk okl_itiv_pk_csr%ROWTYPE;
1077: l_itiv_rec okl_iti_pvt.itiv_rec_type;
1078: BEGIN
1079: x_no_data_found := TRUE;
1080: -- Get current database values
1081: OPEN okl_itiv_pk_csr (p_id);