[Home] [Help]
924: l_desc;
925:
926: CLOSE l_inv_csr;
927:
928: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_DESC'
929: THEN
930: l_desc := l_name;
931: ELSE
932: l_desc := l_desc;
1793: Close check_renis_xfd;
1794:
1795:
1796: If l_trf = 'x' Then
1797: return(fnd_profile.value('OKC_CONTRACT_IDENTIFIER'));
1798: Else
1799: return(null);
1800:
1801: End If;
2025: 'Begin'
2026: );
2027: END IF;
2028:
2029: l_ren_identifier := fnd_profile.value('OKC_CONTRACT_IDENTIFIER');
2030: OPEN get_hdr_details_csr;
2031:
2032: FETCH get_hdr_details_csr
2033: BULK COLLECT INTO hdr_id,
2149: (sysdate+l_time)||' '||to_char(sysdate + l_time,'HH24:MI:SS');
2150: ELSE
2151:
2152: l_chrv_tbl_in (i).contract_number_modifier :=
2153: fnd_profile.value('OKS_TRANSFER_CONTRACT_IDENTIFIER')
2154: ||':'||(sysdate+l_time)||' '|| to_char(sysdate + l_time,'HH24:MI:SS');
2155:
2156: END IF;
2157: ar_interface_yn(i) := 'N';
2199: -- Contract number modifier
2200: IF p_batch_rules.contract_modifier IS NOT NULL
2201: THEN
2202: l_chrv_tbl_in (i).contract_number_modifier :=
2203: Nvl(p_batch_rules.contract_modifier ,fnd_profile.value('OKS_TRANSFER_CONTRACT_IDENTIFIER'))
2204: ||':'|| sysdate ||' '||to_char(sysdate,'HH24:MI:SS');
2205: Else
2206: l_chrv_tbl_in (i).contract_number_modifier := Null;
2207: End If;
2216: (sysdate+l_time)||' '||to_char(sysdate + l_time,'HH24:MI:SS');
2217: ELSE
2218:
2219: l_chrv_tbl_in (i).contract_number_modifier :=
2220: nvl(hdr_identifier (i),fnd_profile.value('OKS_TRANSFER_CONTRACT_IDENTIFIER'))
2221: ||':'||(sysdate+l_time)||' '|| to_char(sysdate + l_time,'HH24:MI:SS');
2222:
2223:
2224: END IF;
2562: l_cpl_tbl_in (j).last_updated_by := fnd_global.user_id;
2563: l_cpl_tbl_in (j).last_update_date := SYSDATE;
2564: l_cpl_tbl_in (j).last_update_login := fnd_global.login_id;
2565: If l_lse_id <> 14 Then
2566: If NVL(fnd_profile.value('OKS_USE_JTF'),'NO') = 'YES' Then
2567:
2568: --Vendor Contact Derived from territory Setup
2569: OKS_EXTWARPRGM_PVT.GET_JTF_RESOURCE (p_authorg_id => hdr_authoring_org_id (i),
2570: p_party_id => p_batch_rules.new_party_id ,
2615: END IF;
2616:
2617: END IF;
2618: fnd_file.put_line(fnd_file.log,'l_salesrep_id value'||l_salesrep_id);
2619: If l_salesrep_id Is Not Null And fnd_profile.VALUE('OKS_VENDOR_CONTACT_ROLE' ) IS NOT NULL THEN
2620: l_salesgroup_id := Null;
2621: fnd_file.put_line(fnd_file.log,'l_salesrep_id not nul');
2622: l_salesgroup_id := jtf_rs_integration_pub.get_default_sales_group
2623: (p_salesrep_id => l_salesrep_id,
2624: p_org_id => hdr_authoring_org_id (i),
2625: p_date => hdr_start_date (i));
2626:
2627:
2628: OPEN object_code_csr( fnd_profile.VALUE('OKS_VENDOR_CONTACT_ROLE' ));
2629: FETCH object_code_csr INTO l_temp;
2630: IF object_code_csr%NOTFOUND THEN
2631: CLOSE object_code_csr;
2632: OKC_API.SET_MESSAGE(
2648: l_ctcv_tbl_in (k).object_version_number := 1;
2649:
2650: l_ctcv_tbl_in (k).cpl_id := l_cpl_tbl_in (j).ID;
2651:
2652: l_ctcv_tbl_in (k).cro_code := fnd_profile.VALUE('OKS_VENDOR_CONTACT_ROLE' );
2653: l_ctcv_tbl_in (k).dnz_chr_id := hdr_id (i);
2654: l_ctcv_tbl_in (k).contact_sequence := 1;
2655: l_ctcv_tbl_in (k).object1_id1 := l_salesrep_id;
2656: l_ctcv_tbl_in (k).object1_id2 := '#';
5754: l_relationship_type VARCHAR2 (40);
5755: l_relationship VARCHAR2 (40);
5756: l_date DATE;
5757: BEGIN
5758: l_relationship_type := fnd_profile.VALUE ('OKS_TRF_PARTY_REL');
5759: get_party_id (p_new_customer, l_new_party_id);
5760: get_party_id (p_old_customer, l_old_party_id);
5761:
5762: OPEN l_cust_rel_csr (l_old_party_id,
6532: AND a.subject_id = b1.party_id
6533: )
6534: )
6535: AND a.relationship_type =
6536: fnd_profile.VALUE ('OKS_TRF_PARTY_REL')
6537: AND a.status = 'A'
6538: AND TRUNC (c.transfer_date) BETWEEN TRUNC (a.start_date)
6539: AND TRUNC (a.end_date)
6540: AND b1.cust_account_id = c.new_customer_acct_id