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.OKC_PRICE_PUB dependencies on OKC_RULES_B

Line 314: from okc_rules_b rul,

310: p_object_code Varchar2)
311: Return Varchar2 IS
312: cursor c1 Is
313: select rul.object1_id1
314: from okc_rules_b rul,
315: okc_rule_groups_b rgp
316: where rul.rgp_id = rgp.id
317: and rul.rule_information_category = p_category
318: and rul.jtot_object1_code = p_object_code

Line 320: l_object_id okc_rules_b.object1_id1%TYPE;

316: where rul.rgp_id = rgp.id
317: and rul.rule_information_category = p_category
318: and rul.jtot_object1_code = p_object_code
319: and rgp.cle_id = p_cle_id;
320: l_object_id okc_rules_b.object1_id1%TYPE;
321: BEGIN
322: -- dbms_output.put_line('Get_Line_Rule');
323: Open c1;
324: Fetch c1 Into l_object_id;

Line 339: from okc_rules_b rul,

335: Return Varchar2 IS
336: cursor c1 Is
337: select rul.object1_id1,
338: rul.jtot_object1_code
339: from okc_rules_b rul,
340: okc_rule_groups_b rgp
341: where rul.rgp_id = rgp.id
342: and rul.rule_information_category = p_category
343: and rgp.cle_id = p_cle_id;

Line 344: l_object_id okc_rules_b.object1_id1%TYPE;

340: okc_rule_groups_b rgp
341: where rul.rgp_id = rgp.id
342: and rul.rule_information_category = p_category
343: and rgp.cle_id = p_cle_id;
344: l_object_id okc_rules_b.object1_id1%TYPE;
345: l_jtot_object okc_rules_b.jtot_object1_code%TYPE;
346: l_row_notfound Boolean;
347: BEGIN
348: -- dbms_output.put_line('Get_Line_Pricing_Rule');

Line 345: l_jtot_object okc_rules_b.jtot_object1_code%TYPE;

341: where rul.rgp_id = rgp.id
342: and rul.rule_information_category = p_category
343: and rgp.cle_id = p_cle_id;
344: l_object_id okc_rules_b.object1_id1%TYPE;
345: l_jtot_object okc_rules_b.jtot_object1_code%TYPE;
346: l_row_notfound Boolean;
347: BEGIN
348: -- dbms_output.put_line('Get_Line_Pricing_Rule');
349: Open c1;

Line 371: from okc_rules_b rul,

367: p_object_code VARCHAR2)
368: Return Varchar2 Is
369: cursor c1 Is
370: select rul.object1_id1
371: from okc_rules_b rul,
372: okc_rule_groups_b rgp
373: where rul.rgp_id = rgp.id
374: and rul.rule_information_category = p_category
375: and rul.jtot_object1_code = p_object_code

Line 377: l_object_id okc_rules_b.object1_id1%TYPE;

373: where rul.rgp_id = rgp.id
374: and rul.rule_information_category = p_category
375: and rul.jtot_object1_code = p_object_code
376: and rgp.chr_id = p_chr_id;
377: l_object_id okc_rules_b.object1_id1%TYPE;
378: l_jtot_object okc_rules_b.jtot_object1_code%TYPE;
379: BEGIN
380: -- dbms_output.put_line('Get_Hdr_Rule');
381: Open c1;

Line 378: l_jtot_object okc_rules_b.jtot_object1_code%TYPE;

374: and rul.rule_information_category = p_category
375: and rul.jtot_object1_code = p_object_code
376: and rgp.chr_id = p_chr_id;
377: l_object_id okc_rules_b.object1_id1%TYPE;
378: l_jtot_object okc_rules_b.jtot_object1_code%TYPE;
379: BEGIN
380: -- dbms_output.put_line('Get_Hdr_Rule');
381: Open c1;
382: Fetch c1 Into l_object_id;

Line 397: from okc_rules_b rul,

393: Return Varchar2 Is
394: cursor c1 Is
395: select rul.object1_id1,
396: rul.jtot_object1_code
397: from okc_rules_b rul,
398: okc_rule_groups_b rgp
399: where rul.rgp_id = rgp.id
400: and rul.rule_information_category = p_category
401: and rgp.chr_id = p_chr_id;

Line 402: l_object_id okc_rules_b.object1_id1%TYPE;

398: okc_rule_groups_b rgp
399: where rul.rgp_id = rgp.id
400: and rul.rule_information_category = p_category
401: and rgp.chr_id = p_chr_id;
402: l_object_id okc_rules_b.object1_id1%TYPE;
403: l_jtot_object okc_rules_b.jtot_object1_code%TYPE;
404: l_row_notfound Boolean;
405: BEGIN
406: -- dbms_output.put_line('Get_Hdr_Pricing_Rule');

Line 403: l_jtot_object okc_rules_b.jtot_object1_code%TYPE;

399: where rul.rgp_id = rgp.id
400: and rul.rule_information_category = p_category
401: and rgp.chr_id = p_chr_id;
402: l_object_id okc_rules_b.object1_id1%TYPE;
403: l_jtot_object okc_rules_b.jtot_object1_code%TYPE;
404: l_row_notfound Boolean;
405: BEGIN
406: -- dbms_output.put_line('Get_Hdr_Pricing_Rule');
407: Open c1;

Line 753: ,OKC_RULES_B RL

749: RULE_INFORMATION2,
750: RULE_INFORMATION3,
751: RULE_INFORMATION4
752: From OKC_RULE_GROUPS_B RG
753: ,OKC_RULES_B RL
754: Where RG.CLE_ID = p_contract_line_id
755: AND RG.ID = RL.RGP_ID
756: AND RULE_INFORMATION_CATEGORY = l_cat;
757: