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.OKC_OPPORTUNITY_PVT dependencies on OKC_K_REL_OBJS

Line 7: g_rty_code okc_k_rel_objs.rty_code%TYPE;

3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: g_sales_rep Number;
7: g_rty_code okc_k_rel_objs.rty_code%TYPE;
8: g_opp_h_created Boolean;
9: --
10: PROCEDURE CREATE_OPPORTUNITY(p_api_version IN NUMBER,
11: p_context IN VARCHAR2,

Line 139: okc_k_rel_objs rel

135: h.orig_system_source_code,
136: h.orig_system_id1,
137: rel.object1_id1 lead_id
138: from okc_k_headers_v h,
139: okc_k_rel_objs rel
140: where h.id = p_contract_id
141: and rel.chr_id(+) = h.orig_system_id1
142: and rel.rty_code(+) = 'OPPEXPSCONTRACT'
143: and rel.jtot_object1_code(+) = 'OKX_OPPHEAD';

Line 210: l_in_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;

206:
207: c7_rec c7%ROWTYPE;
208:
209: l_header_rec as_opportunity_pub.header_rec_type;
210: l_in_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
211: l_out_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
212: l_return_status Varchar2(1);
213: l_msg_count Number;
214: l_msg_data Varchar2(255);

Line 211: l_out_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;

207: c7_rec c7%ROWTYPE;
208:
209: l_header_rec as_opportunity_pub.header_rec_type;
210: l_in_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
211: l_out_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
212: l_return_status Varchar2(1);
213: l_msg_count Number;
214: l_msg_data Varchar2(255);
215: l_lead_id Number;

Line 459: okc_k_rel_objs_pub.Create_Row(

455: IF (l_debug = 'Y') THEN
456: okc_debug.log('3530: Before creating relation objects');
457: END IF;
458: -- Call the rel object api
459: okc_k_rel_objs_pub.Create_Row(
460: p_api_version => 1.0, --p_api_version,--1.0,
461: p_init_msg_list => p_init_msg_list, --okc_api.g_false,
462: x_return_status => l_return_status,
463: x_msg_count => l_msg_count,

Line 585: l_in_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;

581: --
582: l_header_rec as_opportunity_pub.header_rec_type;
583: l_line_tbl as_opportunity_pub.line_tbl_type;
584: l_line_out_tbl as_opportunity_pub.line_out_tbl_type;
585: l_in_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
586: l_out_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
587: --
588: l_org_id Number;
589: l_count Number;

Line 586: l_out_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;

582: l_header_rec as_opportunity_pub.header_rec_type;
583: l_line_tbl as_opportunity_pub.line_tbl_type;
584: l_line_out_tbl as_opportunity_pub.line_out_tbl_type;
585: l_in_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
586: l_out_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
587: --
588: l_org_id Number;
589: l_count Number;
590: l_row_notfound Boolean;

Line 628: from okc_k_rel_objs rel

624: and sts.ste_code in ('ACTIVE', 'SIGNED'))
625: or (p_context in ('AUTHORING', 'RENEW')
626: and sts.ste_code = 'ENTERED'))
627: and not exists (select 'x'
628: from okc_k_rel_objs rel
629: where (rel.cle_id = cle2.id
630: or rel.cle_id = cle2.cle_id)
631: and rel.rty_code = g_rty_code))
632: connect by prior cle.id = cle.cle_id;

Line 661: and not exists (select 'x' from okc_k_rel_objs rel

657: and jou.object_user_code = 'OKX_MTL_SYSTEM_ITEM'
658: and sts.ste_code <> 'TERMINATED'
659: and ((p_context = 'EXPIRE' and sts.ste_code in ('ACTIVE', 'SIGNED'))
660: or (p_context in ('AUTHORING', 'RENEW') and sts.ste_code = 'ENTERED'))
661: and not exists (select 'x' from okc_k_rel_objs rel
662: where (rel.cle_id = cle.id
663: or rel.cle_id = cle.cle_id)
664: and rel.rty_code = g_rty_code)
665: ;

Line 693: from okc_k_rel_objs rel

689: and sts.ste_code in ('ACTIVE', 'SIGNED'))
690: or (p_context in ('AUTHORING', 'RENEW')
691: and sts.ste_code = 'ENTERED'))
692: and not exists (select 'x'
693: from okc_k_rel_objs rel
694: where (rel.cle_id = cle2.id
695: or rel.cle_id = cle2.cle_id)
696: and rel.rty_code = g_rty_code))
697: connect by prior cle.id = cle.cle_id;

Line 702: from okc_k_rel_objs rel

698: */
699: --
700: cursor exp_rel_csr (p_cle_id okc_k_items.cle_id%TYPE)is
701: select object1_id1, object1_id2
702: from okc_k_rel_objs rel
703: where rel.cle_id = p_cle_id
704: and rel.rty_code = 'OPPEXPSCONTRACT';
705: --
706: /* cursor item_csr (p_cle_id okc_k_items.cle_id%TYPE)is

Line 1065: okc_k_rel_objs_pub.Create_Row(

1061: okc_debug.log('5091: Before creating relation objects');
1062: okc_debug.log('5092: '||l_in_crjv_tbl.count||' relation lines to be created ');
1063: END IF;
1064: -- Call the api here
1065: okc_k_rel_objs_pub.Create_Row(
1066: p_api_version => 1.0, --p_api_version
1067: p_init_msg_list => p_init_msg_list,
1068: x_return_status => l_return_status,
1069: x_msg_count => l_msg_count,

Line 1188: from okc_k_rel_objs rel

1184: -- where cle.dnz_chr_id = p_contract_id
1185: where cle.chr_id = p_contract_id
1186: and cle.date_renewed is null
1187: and not exists (select 'x'
1188: from okc_k_rel_objs rel
1189: where (rel.cle_id = cle.id
1190: or rel.cle_id = cle.cle_id)
1191: and rel.rty_code = g_rty_code);
1192: --