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.OKS_OCINT_PUB dependencies on OKS_REP_PVT

Line 125: l_repv_rec oks_rep_pvt.repv_rec_type;

121: l_oe_line_rec oe_order_pub.line_rec_type;
122: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
123: l_navigation VARCHAR2 (240)
124: DEFAULT DBMS_AQ.next_message;
125: l_repv_rec oks_rep_pvt.repv_rec_type;
126: l_out_repv_rec oks_rep_pvt.repv_rec_type;
127: l_request_id NUMBER;
128: --General Variables
129: l_ctr NUMBER;

Line 126: l_out_repv_rec oks_rep_pvt.repv_rec_type;

122: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
123: l_navigation VARCHAR2 (240)
124: DEFAULT DBMS_AQ.next_message;
125: l_repv_rec oks_rep_pvt.repv_rec_type;
126: l_out_repv_rec oks_rep_pvt.repv_rec_type;
127: l_request_id NUMBER;
128: --General Variables
129: l_ctr NUMBER;
130: l_oldline_count NUMBER;

Line 530: p_upd_rec IN oks_rep_pvt.repv_rec_type

526: END oc_interface;
527:
528: PROCEDURE handle_order_error (
529: x_return_status OUT NOCOPY VARCHAR2,
530: p_upd_rec IN oks_rep_pvt.repv_rec_type
531: )
532: IS
533: CURSOR l_old_repv_csr (p_id NUMBER)
534: IS

Line 541: l_new_repv_rec oks_rep_pvt.repv_rec_type;

537: WHERE ID = p_id;
538:
539: --l_old_repv_rec l_old_repv_csr%ROWTYPE;
540: l_obj_vers_num NUMBER;
541: l_new_repv_rec oks_rep_pvt.repv_rec_type;
542: l_repv_rec oks_rep_pvt.repv_rec_type;
543: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
544: l_msg_count NUMBER;
545: l_msg_data VARCHAR2 (2000);

Line 542: l_repv_rec oks_rep_pvt.repv_rec_type;

538:
539: --l_old_repv_rec l_old_repv_csr%ROWTYPE;
540: l_obj_vers_num NUMBER;
541: l_new_repv_rec oks_rep_pvt.repv_rec_type;
542: l_repv_rec oks_rep_pvt.repv_rec_type;
543: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
544: l_msg_count NUMBER;
545: l_msg_data VARCHAR2 (2000);
546: l_index NUMBER;

Line 775: l_repv_tbl oks_rep_pvt.repv_tbl_type;

771: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
772: x_msg_count NUMBER;
773: x_msg_data VARCHAR2 (2000);
774: x_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
775: l_repv_tbl oks_rep_pvt.repv_tbl_type;
776: l_reproc_line_rec oks_rep_pvt.repv_rec_type;
777: l_serv_ref_rec l_serv_ref_csr%ROWTYPE;
778: l_upd_tbl oks_rep_pvt.repv_tbl_type;
779: l_out_repv_rec oks_rep_pvt.repv_rec_type;

Line 776: l_reproc_line_rec oks_rep_pvt.repv_rec_type;

772: x_msg_count NUMBER;
773: x_msg_data VARCHAR2 (2000);
774: x_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
775: l_repv_tbl oks_rep_pvt.repv_tbl_type;
776: l_reproc_line_rec oks_rep_pvt.repv_rec_type;
777: l_serv_ref_rec l_serv_ref_csr%ROWTYPE;
778: l_upd_tbl oks_rep_pvt.repv_tbl_type;
779: l_out_repv_rec oks_rep_pvt.repv_rec_type;
780: l_conc_rec oks_rep_pvt.repv_rec_type;

Line 778: l_upd_tbl oks_rep_pvt.repv_tbl_type;

774: x_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
775: l_repv_tbl oks_rep_pvt.repv_tbl_type;
776: l_reproc_line_rec oks_rep_pvt.repv_rec_type;
777: l_serv_ref_rec l_serv_ref_csr%ROWTYPE;
778: l_upd_tbl oks_rep_pvt.repv_tbl_type;
779: l_out_repv_rec oks_rep_pvt.repv_rec_type;
780: l_conc_rec oks_rep_pvt.repv_rec_type;
781: i NUMBER;
782: l_ctr1 NUMBER;

Line 779: l_out_repv_rec oks_rep_pvt.repv_rec_type;

775: l_repv_tbl oks_rep_pvt.repv_tbl_type;
776: l_reproc_line_rec oks_rep_pvt.repv_rec_type;
777: l_serv_ref_rec l_serv_ref_csr%ROWTYPE;
778: l_upd_tbl oks_rep_pvt.repv_tbl_type;
779: l_out_repv_rec oks_rep_pvt.repv_rec_type;
780: l_conc_rec oks_rep_pvt.repv_rec_type;
781: i NUMBER;
782: l_ctr1 NUMBER;
783: l_cont_line_id NUMBER;

Line 780: l_conc_rec oks_rep_pvt.repv_rec_type;

776: l_reproc_line_rec oks_rep_pvt.repv_rec_type;
777: l_serv_ref_rec l_serv_ref_csr%ROWTYPE;
778: l_upd_tbl oks_rep_pvt.repv_tbl_type;
779: l_out_repv_rec oks_rep_pvt.repv_rec_type;
780: l_conc_rec oks_rep_pvt.repv_rec_type;
781: i NUMBER;
782: l_ctr1 NUMBER;
783: l_cont_line_id NUMBER;
784: l_dummy VARCHAR2 (30);

Line 791: p_reproc_line_rec oks_rep_pvt.repv_rec_type,

787:
788: l_process_status VARCHAR2(20);
789:
790: PROCEDURE create_contract (
791: p_reproc_line_rec oks_rep_pvt.repv_rec_type,
792: x_upd_tbl OUT NOCOPY oks_rep_pvt.repv_tbl_type,
793: x_return_status OUT NOCOPY VARCHAR2
794: )
795: IS

Line 792: x_upd_tbl OUT NOCOPY oks_rep_pvt.repv_tbl_type,

788: l_process_status VARCHAR2(20);
789:
790: PROCEDURE create_contract (
791: p_reproc_line_rec oks_rep_pvt.repv_rec_type,
792: x_upd_tbl OUT NOCOPY oks_rep_pvt.repv_tbl_type,
793: x_return_status OUT NOCOPY VARCHAR2
794: )
795: IS
796: CURSOR l_party_csr

Line 2376: x_repv_tbl OUT NOCOPY oks_rep_pvt.repv_tbl_type

2372: PROCEDURE get_order_details (
2373: p_option IN VARCHAR2,
2374: p_source IN VARCHAR2,
2375: x_return_status OUT NOCOPY VARCHAR2,
2376: x_repv_tbl OUT NOCOPY oks_rep_pvt.repv_tbl_type
2377: )
2378: IS
2379: --mmadhavi modified cursors for MOAC
2380: CURSOR l_order_line_sub_csr

Line 2407: l_repv_tbl oks_rep_pvt.repv_tbl_type;

2403: WHERE NVL (success_flag, 'E') IN ('E', 'N') ---IN ('R','N','E')
2404: AND rep.order_id = oh.header_id
2405: AND conc_request_id IS NULL;
2406:
2407: l_repv_tbl oks_rep_pvt.repv_tbl_type;
2408: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2409: l_ordline_rec oks_rep_pvt.repv_rec_type;
2410: l_ptr NUMBER;
2411: l_source VARCHAR2 (30);

Line 2409: l_ordline_rec oks_rep_pvt.repv_rec_type;

2405: AND conc_request_id IS NULL;
2406:
2407: l_repv_tbl oks_rep_pvt.repv_tbl_type;
2408: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2409: l_ordline_rec oks_rep_pvt.repv_rec_type;
2410: l_ptr NUMBER;
2411: l_source VARCHAR2 (30);
2412:
2413: PROCEDURE get_order_lines (

Line 2419: x_repv_tbl OUT NOCOPY oks_rep_pvt.repv_tbl_type,

2415: p_order_id IN NUMBER,
2416: p_ord_num IN NUMBER,
2417: p_success_flag IN VARCHAR2,
2418: p_source_flag IN VARCHAR2,
2419: x_repv_tbl OUT NOCOPY oks_rep_pvt.repv_tbl_type,
2420: x_return_status OUT NOCOPY VARCHAR2
2421: )
2422: IS
2423: CURSOR get_order_lines_csr (p_ord_num NUMBER)

Line 2461: l_repv_rec oks_rep_pvt.repv_rec_type;

2457: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
2458: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2459: l_msg_count NUMBER := 0;
2460: l_msg_data VARCHAR2 (2000);
2461: l_repv_rec oks_rep_pvt.repv_rec_type;
2462: l_out_repv_rec oks_rep_pvt.repv_rec_type;
2463: BEGIN
2464: fnd_file.put_line (fnd_file.LOG,
2465: 'Inside procedure Get Order Lines'

Line 2462: l_out_repv_rec oks_rep_pvt.repv_rec_type;

2458: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
2459: l_msg_count NUMBER := 0;
2460: l_msg_data VARCHAR2 (2000);
2461: l_repv_rec oks_rep_pvt.repv_rec_type;
2462: l_out_repv_rec oks_rep_pvt.repv_rec_type;
2463: BEGIN
2464: fnd_file.put_line (fnd_file.LOG,
2465: 'Inside procedure Get Order Lines'
2466: );

Line 3659: l_del_rec oks_rep_pvt.repv_rec_type;

3655: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3656: l_msg_count NUMBER;
3657: l_msg_data VARCHAR2 (2000);
3658: l_user_id NUMBER;
3659: l_del_rec oks_rep_pvt.repv_rec_type;
3660: l_repv_tbl oks_rep_pvt.repv_tbl_type;
3661: l_index NUMBER;
3662: l_line_count NUMBER;
3663: l_api_version CONSTANT NUMBER := 1.0;

Line 3660: l_repv_tbl oks_rep_pvt.repv_tbl_type;

3656: l_msg_count NUMBER;
3657: l_msg_data VARCHAR2 (2000);
3658: l_user_id NUMBER;
3659: l_del_rec oks_rep_pvt.repv_rec_type;
3660: l_repv_tbl oks_rep_pvt.repv_tbl_type;
3661: l_index NUMBER;
3662: l_line_count NUMBER;
3663: l_api_version CONSTANT NUMBER := 1.0;
3664: l_init_msg_list VARCHAR2 (1) DEFAULT fnd_api.g_false;

Line 3670: x_repv_tbl OUT NOCOPY oks_rep_pvt.repv_tbl_type

3666: PROCEDURE get_order_lines (
3667: x_return_status OUT NOCOPY VARCHAR2,
3668: x_msg_count OUT NOCOPY NUMBER,
3669: x_msg_data OUT NOCOPY VARCHAR2,
3670: x_repv_tbl OUT NOCOPY oks_rep_pvt.repv_tbl_type
3671: )
3672: IS
3673: CURSOR l_order_line_csr
3674: IS

Line 3679: l_repv_tbl oks_rep_pvt.repv_tbl_type;

3675: SELECT ID
3676: FROM oks_reprocessing_v
3677: WHERE success_flag = 'S';
3678:
3679: l_repv_tbl oks_rep_pvt.repv_tbl_type;
3680: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3681: l_ordline_rec oks_rep_pvt.repv_rec_type;
3682: l_ptr NUMBER;
3683: BEGIN

Line 3681: l_ordline_rec oks_rep_pvt.repv_rec_type;

3677: WHERE success_flag = 'S';
3678:
3679: l_repv_tbl oks_rep_pvt.repv_tbl_type;
3680: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
3681: l_ordline_rec oks_rep_pvt.repv_rec_type;
3682: l_ptr NUMBER;
3683: BEGIN
3684: fnd_file.put_line (fnd_file.LOG, 'Inside procedure Get Order lines');
3685: l_ptr := 0;

Line 3829: l_repv_rec oks_rep_pvt.repv_rec_type;

3825: l_oe_line_rec oe_order_pub.line_rec_type;
3826: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
3827: l_navigation VARCHAR2 (240)
3828: DEFAULT DBMS_AQ.next_message;
3829: l_repv_rec oks_rep_pvt.repv_rec_type;
3830: l_out_repv_rec oks_rep_pvt.repv_rec_type;
3831: l_request_id NUMBER;
3832: --General Variables
3833: l_ctr NUMBER;

Line 3830: l_out_repv_rec oks_rep_pvt.repv_rec_type;

3826: l_dequeue_mode VARCHAR2 (240) DEFAULT DBMS_AQ.remove;
3827: l_navigation VARCHAR2 (240)
3828: DEFAULT DBMS_AQ.next_message;
3829: l_repv_rec oks_rep_pvt.repv_rec_type;
3830: l_out_repv_rec oks_rep_pvt.repv_rec_type;
3831: l_request_id NUMBER;
3832: --General Variables
3833: l_ctr NUMBER;
3834: l_oldline_count NUMBER;