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_AUTO_REMINDER dependencies on OKS_K_HEADERS_B

Line 56: FROM oks_k_headers_b

52: p_chr_id NUMBER
53: )
54: IS
55: SELECT quote_to_email_id
56: FROM oks_k_headers_b
57: WHERE chr_id = p_chr_id;
58:
59: CURSOR l_emailaddress_csr (
60: p_contactpoint_id NUMBER

Line 160: FROM oks_k_headers_b kh,

156: IS
157: /*
158: CURSOR l_QtoPartyId_csr IS
159: SELECT hzr.party_id
160: FROM oks_k_headers_b kh,
161: --NPALEPU
162: --08-AUG-2005
163: --TCA Project
164: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts with OKS_RA_HCONTACTS_V

Line 183: l_person_party_id oks_k_headers_b.person_party_id%TYPE;

179: --END NPALEPU
180: */
181:
182: -- skekkar
183: l_person_party_id oks_k_headers_b.person_party_id%TYPE;
184: l_quote_to_contact_id oks_k_headers_b.quote_to_contact_id%TYPE;
185:
186: CURSOR csr_person_party_id
187: IS

Line 184: l_quote_to_contact_id oks_k_headers_b.quote_to_contact_id%TYPE;

180: */
181:
182: -- skekkar
183: l_person_party_id oks_k_headers_b.person_party_id%TYPE;
184: l_quote_to_contact_id oks_k_headers_b.quote_to_contact_id%TYPE;
185:
186: CURSOR csr_person_party_id
187: IS
188: SELECT ks.person_party_id,

Line 190: FROM oks_k_headers_b ks

186: CURSOR csr_person_party_id
187: IS
188: SELECT ks.person_party_id,
189: ks.quote_to_contact_id
190: FROM oks_k_headers_b ks
191: WHERE ks.chr_id = p_chr_id;
192:
193: CURSOR csr_qtc_person_party_id (
194: p_quote_to_contact_id IN NUMBER

Line 214: -- Get the Person Party Id and quote_to_contact_id from oks_k_headers_b

210: FETCH l_QtoPartyId_csr into x_party_id;
211: CLOSE l_QtoPartyId_csr;
212: */
213:
214: -- Get the Person Party Id and quote_to_contact_id from oks_k_headers_b
215: OPEN csr_person_party_id;
216:
217: FETCH csr_person_party_id
218: INTO l_person_party_id,

Line 401: oks_k_headers_b ks

397: SELECT hzp.party_id
398: FROM hz_cust_account_roles car,
399: hz_relationships rln,
400: hz_parties hzp,
401: oks_k_headers_b ks
402: WHERE ks.quote_to_contact_id = car.cust_account_role_id
403: AND car.party_id = rln.party_id
404: AND rln.subject_id = hzp.party_id
405: AND car.role_type = 'CONTACT'

Line 834: UPDATE oks_k_headers_b

830: p_term_cancel_source => 'CUSTOMER',
831: p_date_cancelled => SYSDATE,
832: p_validate_status => 'N') ;
833:
834: UPDATE oks_k_headers_b
835: SET renewal_status = 'QUOTE_CNCLD'
836: WHERE chr_id = p_chr_id;
837: /*end of bug8345674*/
838: ELSE

Line 2246: FROM oks_k_headers_b

2242: l_salesrep_name VARCHAR2 (1000);
2243:
2244: CURSOR csr_k_hdr_details IS
2245: SELECT DECODE (renewal_type_used,NULL,'N','R'), wf_item_key
2246: FROM oks_k_headers_b
2247: WHERE chr_id = p_chr_id;
2248:
2249: CURSOR csr_xdo_template_name(p_attachment_template_id IN NUMBER) IS
2250: SELECT template_name

Line 2257: from oks_k_headers_b

2253:
2254: /*added for bug6956935*/
2255: Cursor l_chrv_csr(p_chr_id NUMBER) Is
2256: select 'Y'
2257: from oks_k_headers_b
2258: where chr_id = p_chr_id
2259: and RENEWAL_TYPE_USED = 'ERN'
2260: and date_accepted is not null;
2261:

Line 2676: Step 1: Get the person_party_id from oks_k_headers_b

2672: PROCEDURE create_sso_user
2673: Pseudo Logic:
2674: -------------
2675:
2676: Step 1: Get the person_party_id from oks_k_headers_b
2677:
2678: IF oks_k_headers_b.person_party_id IS NULL THEN
2679: Fetch the person_party_id for quote to contact id
2680: UPDATE oks_k_headers_b record with the person_party_id for quote to contact id

Line 2678: IF oks_k_headers_b.person_party_id IS NULL THEN

2674: -------------
2675:
2676: Step 1: Get the person_party_id from oks_k_headers_b
2677:
2678: IF oks_k_headers_b.person_party_id IS NULL THEN
2679: Fetch the person_party_id for quote to contact id
2680: UPDATE oks_k_headers_b record with the person_party_id for quote to contact id
2681:
2682: Step 2: Check if record exists in fnd_user for the above person_party_id (filter expired records here)

Line 2680: UPDATE oks_k_headers_b record with the person_party_id for quote to contact id

2676: Step 1: Get the person_party_id from oks_k_headers_b
2677:
2678: IF oks_k_headers_b.person_party_id IS NULL THEN
2679: Fetch the person_party_id for quote to contact id
2680: UPDATE oks_k_headers_b record with the person_party_id for quote to contact id
2681:
2682: Step 2: Check if record exists in fnd_user for the above person_party_id (filter expired records here)
2683: -- 1 or more Record Exists
2684: If record found then

Line 2725: Update the person_party_id of oks_k_headers_b and continue publishing

2721: UPDATE fnd_user record with person_party_id from step 1 above
2722: CASE 2: person_party_id of fnd_user DOES NOT MATCH the person_party_id from step 1 above
2723: (logic introduced as part of bugfix for 58983305)
2724: CASE i: If the value of the profile option OKS Overide SSO Behaviour is Y then
2725: Update the person_party_id of oks_k_headers_b and continue publishing
2726: CASE ii:If the value of the profile option OKS Overide SSO Behaviour is N
2727: RAISE error here
2728: CASE 3: person_party_id of fnd_user MATCHES the person_party_id from step 1 above
2729: we are fine, do nothing

Line 2749: l_person_party_id oks_k_headers_b.person_party_id%TYPE;

2745: )
2746: AS
2747: l_api_name CONSTANT VARCHAR2 (30)
2748: := 'create_sso_user';
2749: l_person_party_id oks_k_headers_b.person_party_id%TYPE;
2750: l_fnd_person_party_id fnd_user.person_party_id%TYPE;
2751: l_start_date fnd_user.start_date%TYPE;
2752: l_end_date fnd_user.end_date%TYPE;
2753: l_test_user PLS_INTEGER;

Line 2758: l_quote_to_contact_id oks_k_headers_b.quote_to_contact_id%TYPE;

2754: l_responsibility_id fnd_responsibility_vl.responsibility_id%TYPE;
2755: l_security_grp_id fnd_security_groups.security_group_id%TYPE;
2756: l_return_value BOOLEAN;
2757: l_user_id fnd_user.user_id%TYPE;
2758: l_quote_to_contact_id oks_k_headers_b.quote_to_contact_id%TYPE;
2759:
2760: l_suggested_user_name fnd_user.user_name%TYPE;
2761:
2762: CURSOR csr_person_party_id

Line 2766: FROM oks_k_headers_b ks

2762: CURSOR csr_person_party_id
2763: IS
2764: SELECT ks.person_party_id,
2765: ks.quote_to_contact_id
2766: FROM oks_k_headers_b ks
2767: WHERE ks.chr_id = p_contract_id;
2768:
2769: CURSOR csr_qtc_person_party_id (
2770: p_quote_to_contact_id IN NUMBER

Line 2892: -- Get the Person Party Id and quote_to_contact_id from oks_k_headers_b

2888: fnd_file.put_line (fnd_file.LOG, ' ');
2889: -- Initialize API return status to success
2890: x_return_status := fnd_api.g_ret_sts_success;
2891:
2892: -- Get the Person Party Id and quote_to_contact_id from oks_k_headers_b
2893: OPEN csr_person_party_id;
2894:
2895: FETCH csr_person_party_id
2896: INTO l_person_party_id,

Line 2954: -- update the oks_k_headers_b with the person_party_id

2950: fnd_file.put_line (fnd_file.LOG,
2951: 'HZ l_person_party_id : ' ||
2952: l_person_party_id);
2953:
2954: -- update the oks_k_headers_b with the person_party_id
2955: UPDATE oks_k_headers_b
2956: SET person_party_id = l_person_party_id,
2957: object_version_number = object_version_number +
2958: 1,

Line 2955: UPDATE oks_k_headers_b

2951: 'HZ l_person_party_id : ' ||
2952: l_person_party_id);
2953:
2954: -- update the oks_k_headers_b with the person_party_id
2955: UPDATE oks_k_headers_b
2956: SET person_party_id = l_person_party_id,
2957: object_version_number = object_version_number +
2958: 1,
2959: last_update_date = SYSDATE,

Line 2974: END IF; -- l_person_party_id is null in oks_k_headers_b

2970: last_update_date = SYSDATE,
2971: last_updated_by = fnd_global.user_id,
2972: last_update_login = fnd_global.login_id
2973: WHERE chr_id = p_contract_id;
2974: END IF; -- l_person_party_id is null in oks_k_headers_b
2975:
2976: -- Check if record exists in fnd_user for the above person_party_id
2977: OPEN csr_check_fnd_user_exists (p_person_party_id => l_person_party_id);
2978:

Line 3515: --oks_k_headers_b table accordingly.

3511: ELSIF l_person_party_id <> l_fnd_person_party_id
3512: THEN
3513: --codefix for bug 5893305
3514: --check the value of the profile option oks_override_sso and update
3515: --oks_k_headers_b table accordingly.
3516: IF NVL(FND_PROFILE.VALUE('OKS_OVERRIDE_SSO'),'N') <>'N'
3517: THEN
3518: fnd_file.put_line (fnd_file.LOG,'Overriding SSO behavior');
3519: --update oks_k_headers_b with fnd_profile value.

Line 3519: --update oks_k_headers_b with fnd_profile value.

3515: --oks_k_headers_b table accordingly.
3516: IF NVL(FND_PROFILE.VALUE('OKS_OVERRIDE_SSO'),'N') <>'N'
3517: THEN
3518: fnd_file.put_line (fnd_file.LOG,'Overriding SSO behavior');
3519: --update oks_k_headers_b with fnd_profile value.
3520: UPDATE oks_k_headers_b
3521: SET person_party_id =l_fnd_person_party_id
3522: WHERE chr_id=p_contract_id;
3523: fnd_file.put_line (fnd_file.LOG,'OKS Person Party ID updated to:'||l_fnd_person_party_id);

Line 3520: UPDATE oks_k_headers_b

3516: IF NVL(FND_PROFILE.VALUE('OKS_OVERRIDE_SSO'),'N') <>'N'
3517: THEN
3518: fnd_file.put_line (fnd_file.LOG,'Overriding SSO behavior');
3519: --update oks_k_headers_b with fnd_profile value.
3520: UPDATE oks_k_headers_b
3521: SET person_party_id =l_fnd_person_party_id
3522: WHERE chr_id=p_contract_id;
3523: fnd_file.put_line (fnd_file.LOG,'OKS Person Party ID updated to:'||l_fnd_person_party_id);
3524: ELSE