DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_CONTEXT

Line 2269: AND a.org_id = okc_context.get_okc_org_id;

2265: SELECT a.id1
2266: FROM okx_cust_sites_v a, okx_cust_contacts_v b
2267: WHERE b.id1 = p_contact_id
2268: AND a.id1 = b.cust_acct_site_id
2269: AND a.org_id = okc_context.get_okc_org_id;
2270:
2271: -- party contact id
2272: CURSOR party_cont_cur (p_contact_id NUMBER)
2273: IS

Line 2326: AND org_id = okc_context.get_okc_org_id

2322: IS
2323: SELECT GROUP_ID
2324: FROM jtf_rs_srp_groups
2325: WHERE salesrep_id = p_id
2326: AND org_id = okc_context.get_okc_org_id
2327: AND p_start_date BETWEEN start_date AND end_date
2328: AND p_end_date BETWEEN start_date AND end_date;
2329:
2330: CURSOR l_bookdt_csr (p_ord_hdrid NUMBER)

Line 2569: okc_context.get_okc_organization_id

2565: l_chrv_tbl_in (1).scs_code := NVL (p_k_header_rec.scs_code, 'WARRANTY');
2566: l_chrv_tbl_in (1).authoring_org_id := p_k_header_rec.authoring_org_id;
2567: l_chrv_tbl_in (1).inv_organization_id :=
2568: NVL (p_k_header_rec.inv_organization_id,
2569: okc_context.get_okc_organization_id
2570: );
2571: l_chrv_tbl_in (1).pre_pay_req_yn := 'N';
2572: l_chrv_tbl_in (1).cust_po_number := p_k_header_rec.cust_po_number;
2573: l_chrv_tbl_in (1).qcl_id := p_k_header_rec.qcl_id;

Line 3238: l_new_org_id := okc_context.get_okc_org_id;

3234: send_notification (p_k_header_rec.order_hdr_id, NULL, 'NRS');
3235: End If;
3236: ELSIF l_count >= 1
3237: THEN
3238: l_new_org_id := okc_context.get_okc_org_id;
3239:
3240: OPEN l_salesrep_csr (l_derived_res_id, l_new_org_id);
3241:
3242: FETCH l_salesrep_csr

Line 3269: p_org_id => okc_context.get_okc_org_id,

3265: THEN
3266: l_salesgroup_id :=
3267: jtf_rs_integration_pub.get_default_sales_group
3268: (p_salesrep_id => l_salesrep_id,
3269: p_org_id => okc_context.get_okc_org_id,
3270: p_date => p_k_header_rec.start_date
3271: );
3272: l_ctcv_tbl_in (1).object1_id1 := l_salesrep_id;
3273: l_ctcv_tbl_in (1).cpl_id := l_partyid_v;

Line 3831: AND org_id = okc_context.get_okc_org_id

3827: IS
3828: SELECT GROUP_ID
3829: FROM jtf_rs_srp_groups
3830: WHERE salesrep_id = p_id
3831: AND org_id = okc_context.get_okc_org_id
3832: AND p_start_date BETWEEN start_date AND end_date
3833: AND p_end_date BETWEEN start_date AND end_date;
3834:
3835: l_sales_group_id NUMBER;

Line 4418: l_cimv_tbl_in (1).object1_id2 := okc_context.get_okc_organization_id;

4414: --Create Contract Item
4415: l_cimv_tbl_in (1).cle_id := l_line_id;
4416: l_cimv_tbl_in (1).dnz_chr_id := p_k_line_rec.k_id;
4417: l_cimv_tbl_in (1).object1_id1 := p_k_line_rec.srv_id;
4418: l_cimv_tbl_in (1).object1_id2 := okc_context.get_okc_organization_id;
4419: l_cimv_tbl_in (1).jtot_object1_code := l_jtot_object;
4420: l_cimv_tbl_in (1).exception_yn := 'N';
4421: l_cimv_tbl_in (1).number_of_items := l_duration;
4422: l_cimv_tbl_in (1).uom_code := l_timeunits;

Line 4454: + okc_context.get_okc_organization_id

4450: g_col_name_token,
4451: 'Service Inventory Item ID '
4452: || p_k_line_rec.srv_id
4453: || ' ORG '
4454: + okc_context.get_okc_organization_id
4455: );
4456: RAISE g_exception_halt_validation;
4457: END IF;
4458:

Line 6823: okc_context.set_okc_org_context

6819: THEN
6820: l_ctr := p_kdtl_tbl.FIRST;
6821:
6822: LOOP
6823: okc_context.set_okc_org_context
6824: (p_kdtl_tbl (l_ctr).hdr_org_id,
6825: p_kdtl_tbl (l_ctr).organization_id
6826: );
6827: l_inst_dtls_tbl.DELETE;

Line 7690: okc_context.set_okc_org_context

7686: THEN
7687: l_ctr := p_kdtl_tbl.FIRST;
7688:
7689: LOOP
7690: okc_context.set_okc_org_context
7691: (p_kdtl_tbl (l_ctr).hdr_org_id,
7692: p_kdtl_tbl (l_ctr).organization_id
7693: );
7694: l_inst_dtls_tbl.DELETE;

Line 8630: okc_context.set_okc_org_context

8626: l_chrv_tbl_in.delete;
8627:
8628: l_inst_dtls_tbl.DELETE;
8629:
8630: okc_context.set_okc_org_context
8631: (p_kdtl_tbl (l_ctr).hdr_org_id,
8632: p_kdtl_tbl (l_ctr).organization_id
8633: );
8634: get_sts_code (NULL,

Line 10883: okc_context.set_okc_org_context

10879: LOOP
10880: --Fix for Bug 5406201
10881: l_clev_tbl_in.delete;
10882: l_chrv_tbl_in.delete;
10883: okc_context.set_okc_org_context
10884: (p_kdtl_tbl (l_ctr).hdr_org_id,
10885: p_kdtl_tbl (l_ctr).organization_id
10886: );
10887: get_party_id (p_kdtl_tbl (l_ctr).new_account_id,

Line 14020: okc_context.set_okc_org_context

14016: l_chrv_tbl_in.delete;
14017: l_inst_dtls_tbl.DELETE;
14018:
14019:
14020: okc_context.set_okc_org_context
14021: (p_kdtl_tbl (l_ctr).hdr_org_id,
14022: p_kdtl_tbl (l_ctr).organization_id
14023: );
14024: get_sts_code (NULL,

Line 14743: okc_context.set_okc_org_context

14739: THEN
14740: l_ctr := p_kdtl_tbl.FIRST;
14741:
14742: LOOP
14743: okc_context.set_okc_org_context
14744: (p_kdtl_tbl (l_ctr).hdr_org_id,
14745: p_kdtl_tbl (l_ctr).organization_id
14746: );
14747:

Line 15502: AND mtl.organization_id = okc_context.get_okc_organization_id;

15498: IS
15499: SELECT mtl.NAME, mtl.description
15500: FROM okx_system_items_v mtl
15501: WHERE mtl.inventory_item_id = p_inventory_item_id
15502: AND mtl.organization_id = okc_context.get_okc_organization_id;
15503:
15504: CURSOR l_bill_csr (p_cle_id NUMBER)
15505: IS
15506: SELECT SUM (amount)

Line 15609: okc_context.set_okc_org_context

15605:
15606: LOOP
15607: l_ptr := 1;
15608: l_inst_dtls_tbl.DELETE;
15609: okc_context.set_okc_org_context
15610: (p_kdtl_tbl (l_ctr).hdr_org_id,
15611: p_kdtl_tbl (l_ctr).organization_id
15612: );
15613: