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 2169: FROM oks_k_headers_b

2165: l_salesrep_name VARCHAR2 (1000);
2166:
2167: CURSOR csr_k_hdr_details IS
2168: SELECT DECODE (renewal_type_used,NULL,'N','R'), wf_item_key
2169: FROM oks_k_headers_b
2170: WHERE chr_id = p_chr_id;
2171:
2172: CURSOR csr_xdo_template_name(p_attachment_template_id IN NUMBER) IS
2173: SELECT template_name

Line 2537: Step 1: Get the person_party_id from oks_k_headers_b

2533: PROCEDURE create_sso_user
2534: Pseudo Logic:
2535: -------------
2536:
2537: Step 1: Get the person_party_id from oks_k_headers_b
2538:
2539: IF oks_k_headers_b.person_party_id IS NULL THEN
2540: Fetch the person_party_id for quote to contact id
2541: UPDATE oks_k_headers_b record with the person_party_id for quote to contact id

Line 2539: IF oks_k_headers_b.person_party_id IS NULL THEN

2535: -------------
2536:
2537: Step 1: Get the person_party_id from oks_k_headers_b
2538:
2539: IF oks_k_headers_b.person_party_id IS NULL THEN
2540: Fetch the person_party_id for quote to contact id
2541: UPDATE oks_k_headers_b record with the person_party_id for quote to contact id
2542:
2543: Step 2: Check if record exists in fnd_user for the above person_party_id (filter expired records here)

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

2537: Step 1: Get the person_party_id from oks_k_headers_b
2538:
2539: IF oks_k_headers_b.person_party_id IS NULL THEN
2540: Fetch the person_party_id for quote to contact id
2541: UPDATE oks_k_headers_b record with the person_party_id for quote to contact id
2542:
2543: Step 2: Check if record exists in fnd_user for the above person_party_id (filter expired records here)
2544: -- 1 or more Record Exists
2545: If record found then

Line 2606: l_person_party_id oks_k_headers_b.person_party_id%TYPE;

2602: )
2603: AS
2604: l_api_name CONSTANT VARCHAR2 (30)
2605: := 'create_sso_user';
2606: l_person_party_id oks_k_headers_b.person_party_id%TYPE;
2607: l_fnd_person_party_id fnd_user.person_party_id%TYPE;
2608: l_start_date fnd_user.start_date%TYPE;
2609: l_end_date fnd_user.end_date%TYPE;
2610: l_test_user PLS_INTEGER;

Line 2615: l_quote_to_contact_id oks_k_headers_b.quote_to_contact_id%TYPE;

2611: l_responsibility_id fnd_responsibility_vl.responsibility_id%TYPE;
2612: l_security_grp_id fnd_security_groups.security_group_id%TYPE;
2613: l_return_value BOOLEAN;
2614: l_user_id fnd_user.user_id%TYPE;
2615: l_quote_to_contact_id oks_k_headers_b.quote_to_contact_id%TYPE;
2616:
2617: l_suggested_user_name fnd_user.user_name%TYPE;
2618:
2619: CURSOR csr_person_party_id

Line 2623: FROM oks_k_headers_b ks

2619: CURSOR csr_person_party_id
2620: IS
2621: SELECT ks.person_party_id,
2622: ks.quote_to_contact_id
2623: FROM oks_k_headers_b ks
2624: WHERE ks.chr_id = p_contract_id;
2625:
2626: CURSOR csr_qtc_person_party_id (
2627: p_quote_to_contact_id IN NUMBER

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

2743: fnd_file.put_line (fnd_file.LOG, ' ');
2744: -- Initialize API return status to success
2745: x_return_status := fnd_api.g_ret_sts_success;
2746:
2747: -- Get the Person Party Id and quote_to_contact_id from oks_k_headers_b
2748: OPEN csr_person_party_id;
2749:
2750: FETCH csr_person_party_id
2751: INTO l_person_party_id,

Line 2809: -- update the oks_k_headers_b with the person_party_id

2805: fnd_file.put_line (fnd_file.LOG,
2806: 'HZ l_person_party_id : ' ||
2807: l_person_party_id);
2808:
2809: -- update the oks_k_headers_b with the person_party_id
2810: UPDATE oks_k_headers_b
2811: SET person_party_id = l_person_party_id,
2812: object_version_number = object_version_number +
2813: 1,

Line 2810: UPDATE oks_k_headers_b

2806: 'HZ l_person_party_id : ' ||
2807: l_person_party_id);
2808:
2809: -- update the oks_k_headers_b with the person_party_id
2810: UPDATE oks_k_headers_b
2811: SET person_party_id = l_person_party_id,
2812: object_version_number = object_version_number +
2813: 1,
2814: last_update_date = SYSDATE,

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

2825: last_update_date = SYSDATE,
2826: last_updated_by = fnd_global.user_id,
2827: last_update_login = fnd_global.login_id
2828: WHERE chr_id = p_contract_id;
2829: END IF; -- l_person_party_id is null in oks_k_headers_b
2830:
2831: -- Check if record exists in fnd_user for the above person_party_id
2832: OPEN csr_check_fnd_user_exists (p_person_party_id => l_person_party_id);
2833: