[Home] [Help]
928: l_desc;
929:
930: CLOSE l_inv_csr;
931:
932: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_DESC'
933: THEN
934: l_desc := l_name;
935: ELSE
936: l_desc := l_desc;
1797: Close check_renis_xfd;
1798:
1799:
1800: If l_trf = 'x' Then
1801: return(fnd_profile.value('OKC_CONTRACT_IDENTIFIER'));
1802: Else
1803: return(null);
1804:
1805: End If;
2030: 'Begin'
2031: );
2032: END IF;
2033:
2034: l_ren_identifier := fnd_profile.value('OKC_CONTRACT_IDENTIFIER');
2035: OPEN get_hdr_details_csr;
2036:
2037: FETCH get_hdr_details_csr
2038: BULK COLLECT INTO hdr_id,
2154: (sysdate+l_time)||' '||to_char(sysdate + l_time,'HH24:MI:SS');
2155: ELSE
2156:
2157: l_chrv_tbl_in (i).contract_number_modifier :=
2158: fnd_profile.value('OKS_TRANSFER_CONTRACT_IDENTIFIER')
2159: ||':'||(sysdate+l_time)||' '|| to_char(sysdate + l_time,'HH24:MI:SS');
2160:
2161: END IF;
2162: ar_interface_yn(i) := 'N';
2204: -- Contract number modifier
2205: IF p_batch_rules.contract_modifier IS NOT NULL
2206: THEN
2207: l_chrv_tbl_in (i).contract_number_modifier :=
2208: Nvl(p_batch_rules.contract_modifier ,fnd_profile.value('OKS_TRANSFER_CONTRACT_IDENTIFIER'))
2209: ||':'|| sysdate ||' '||to_char(sysdate,'HH24:MI:SS');
2210: Else
2211: l_chrv_tbl_in (i).contract_number_modifier := Null;
2212: End If;
2221: (sysdate+l_time)||' '||to_char(sysdate + l_time,'HH24:MI:SS');
2222: ELSE
2223:
2224: l_chrv_tbl_in (i).contract_number_modifier :=
2225: nvl(hdr_identifier (i),fnd_profile.value('OKS_TRANSFER_CONTRACT_IDENTIFIER'))
2226: ||':'||(sysdate+l_time)||' '|| to_char(sysdate + l_time,'HH24:MI:SS');
2227:
2228:
2229: END IF;
2567: l_cpl_tbl_in (j).last_updated_by := fnd_global.user_id;
2568: l_cpl_tbl_in (j).last_update_date := SYSDATE;
2569: l_cpl_tbl_in (j).last_update_login := fnd_global.login_id;
2570: If l_lse_id <> 14 Then
2571: If NVL(fnd_profile.value('OKS_USE_JTF'),'NO') = 'YES' Then
2572:
2573: --Vendor Contact Derived from territory Setup
2574: OKS_EXTWARPRGM_PVT.GET_JTF_RESOURCE (p_authorg_id => hdr_authoring_org_id (i),
2575: p_party_id => p_batch_rules.new_party_id ,
2620: END IF;
2621:
2622: END IF;
2623: fnd_file.put_line(fnd_file.log,'l_salesrep_id value'||l_salesrep_id);
2624: If l_salesrep_id Is Not Null And fnd_profile.VALUE('OKS_VENDOR_CONTACT_ROLE' ) IS NOT NULL THEN
2625: l_salesgroup_id := Null;
2626: fnd_file.put_line(fnd_file.log,'l_salesrep_id not nul');
2627: l_salesgroup_id := jtf_rs_integration_pub.get_default_sales_group
2628: (p_salesrep_id => l_salesrep_id,
2629: p_org_id => hdr_authoring_org_id (i),
2630: p_date => hdr_start_date (i));
2631:
2632:
2633: OPEN object_code_csr( fnd_profile.VALUE('OKS_VENDOR_CONTACT_ROLE' ));
2634: FETCH object_code_csr INTO l_temp;
2635: IF object_code_csr%NOTFOUND THEN
2636: CLOSE object_code_csr;
2637: OKC_API.SET_MESSAGE(
2653: l_ctcv_tbl_in (k).object_version_number := 1;
2654:
2655: l_ctcv_tbl_in (k).cpl_id := l_cpl_tbl_in (j).ID;
2656:
2657: l_ctcv_tbl_in (k).cro_code := fnd_profile.VALUE('OKS_VENDOR_CONTACT_ROLE' );
2658: l_ctcv_tbl_in (k).dnz_chr_id := hdr_id (i);
2659: l_ctcv_tbl_in (k).contact_sequence := 1;
2660: l_ctcv_tbl_in (k).object1_id1 := l_salesrep_id;
2661: l_ctcv_tbl_in (k).object1_id2 := '#';
5771: l_relationship_type VARCHAR2 (40);
5772: l_relationship VARCHAR2 (40);
5773: l_date DATE;
5774: BEGIN
5775: l_relationship_type := fnd_profile.VALUE ('OKS_TRF_PARTY_REL');
5776: get_party_id (p_new_customer, l_new_party_id);
5777: get_party_id (p_old_customer, l_old_party_id);
5778:
5779: OPEN l_cust_rel_csr (l_old_party_id,
6549: AND a.subject_id = b1.party_id
6550: )
6551: )
6552: AND a.relationship_type =
6553: fnd_profile.VALUE ('OKS_TRF_PARTY_REL')
6554: AND a.status = 'A'
6555: AND TRUNC (c.transfer_date) BETWEEN TRUNC (a.start_date)
6556: AND TRUNC (a.end_date)
6557: AND b1.cust_account_id = c.new_customer_acct_id