APPS.PQH_WORKFLOW dependencies on PQH_ATTRIBUTE_RANGES

Line 1572: p_range_name out nocopy pqh_attribute_ranges.range_name%type,

1568: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
1569: p_old_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
1570: p_status_flag out nocopy number,
1571: p_history_flag out nocopy boolean,
1572: p_range_name out nocopy pqh_attribute_ranges.range_name%type,
1573: p_can_approve out nocopy boolean)
1574: as
1575: l_from_clause pqh_table_route.from_clause%type;
1576: l_applicable_flag boolean;

Line 2528: p_range_name out nocopy pqh_attribute_ranges.range_name%type,

2524: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
2525: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
2526: p_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,
2527: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
2528: p_range_name out nocopy pqh_attribute_ranges.range_name%type,
2529: p_status_flag out nocopy number )
2530: as
2531: cursor c1 is
2532: select distinct ar.routing_category_id, ar.range_name

Line 2533: from pqh_attribute_ranges ar

2529: p_status_flag out nocopy number )
2530: as
2531: cursor c1 is
2532: select distinct ar.routing_category_id, ar.range_name
2533: from pqh_attribute_ranges ar
2534: where ar.routing_list_member_id is null
2535: and ar.position_id is null
2536: and ar.assignment_id is null
2537: and nvl(ar.enable_flag,'X') = 'Y'

Line 2559: from pqh_attribute_ranges ar,pqh_routing_categories rc

2555: and nvl(att.enable_flag,'X') = 'Y';
2556: cursor c3(p_attribute_id varchar2) is
2557: select ar.from_char,ar.to_char,ar.from_date,ar.to_date,ar.from_number,
2558: ar.to_number,rc.routing_category_id,ar.range_name
2559: from pqh_attribute_ranges ar,pqh_routing_categories rc
2560: where ar.attribute_id = p_attribute_id
2561: and ar.routing_category_id = rc.routing_category_id
2562: and rc.transaction_category_id = p_tran_cat_id
2563: and ar.routing_list_member_id is null

Line 2588: range_name pqh_attribute_ranges.range_name%type,

2584: l_in_range boolean ;
2585: l_rule_cnt number ;
2586: type list_rec is record (
2587: routing_category_id pqh_routing_categories.routing_category_id%type,
2588: range_name pqh_attribute_ranges.range_name%type,
2589: selected_flag boolean) ;
2590: type list_tab is table of list_rec
2591: index by binary_integer;
2592: l_hierarchy list_tab;

Line 2891: from pqh_attribute_ranges

2887: p_can_approve out nocopy boolean)
2888: as
2889: cursor c1 is
2890: select distinct range_name, NVL(approver_flag,'N') approve_flag
2891: from pqh_attribute_ranges
2892: where assignment_id = p_assignment_id
2893: and routing_category_id = p_routing_category_id
2894: and nvl(enable_flag,'X') = 'Y'
2895: and nvl(delete_flag,'N') = 'N';

Line 2905: from pqh_attribute_ranges

2901: and tca.member_identifying_flag = 'Y'
2902: and nvl(att.enable_flag,'X') = 'Y';
2903: cursor c3(p_attribute_id number) is
2904: select range_name,from_char,to_char,from_date,to_date,from_number,to_number,approver_flag
2905: from pqh_attribute_ranges
2906: where attribute_id = p_attribute_id
2907: and assignment_id = p_assignment_id
2908: and routing_category_id = p_routing_category_id
2909: and nvl(delete_flag,'N') = 'N'

Line 3116: from pqh_attribute_ranges

3112: p_is_std_rule_flag out nocopy varchar2) is
3113: --
3114: Cursor csr_std_rule is
3115: Select attribute_id,nvl(approver_flag,'N') approver_flag
3116: from pqh_attribute_ranges
3117: where position_id = p_position_id
3118: and routing_category_id = p_routing_category_id
3119: and nvl(delete_flag,'N') = 'N'
3120: and nvl(enable_flag,'X') ='Y'

Line 3123: l_attr pqh_attribute_ranges.attribute_id%type;

3119: and nvl(delete_flag,'N') = 'N'
3120: and nvl(enable_flag,'X') ='Y'
3121: and range_name = p_range_name;
3122: --
3123: l_attr pqh_attribute_ranges.attribute_id%type;
3124: l_appr pqh_attribute_ranges.approver_flag%type;
3125: l_cnt number(15);
3126: l_proc varchar2(72) := 'is_std_rule';
3127: --

Line 3124: l_appr pqh_attribute_ranges.approver_flag%type;

3120: and nvl(enable_flag,'X') ='Y'
3121: and range_name = p_range_name;
3122: --
3123: l_attr pqh_attribute_ranges.attribute_id%type;
3124: l_appr pqh_attribute_ranges.approver_flag%type;
3125: l_cnt number(15);
3126: l_proc varchar2(72) := 'is_std_rule';
3127: --
3128: Begin

Line 3164: from pqh_attribute_ranges

3160: p_applicable_flag out nocopy boolean,
3161: p_status_flag out nocopy number,
3162: p_can_approve out nocopy boolean) as
3163: cursor c1 is select distinct range_name
3164: from pqh_attribute_ranges
3165: where position_id = p_position_id
3166: and routing_category_id = p_routing_category_id
3167: and nvl(delete_flag,'N') = 'N'
3168: and nvl(enable_flag,'X') ='Y';

Line 3178: from pqh_attribute_ranges

3174: and tca.member_identifying_flag = 'Y'
3175: and nvl(att.enable_flag,'X') = 'Y';
3176: cursor c3(p_attribute_id number) is
3177: select range_name,from_char,to_char,from_date,to_date,from_number,to_number,approver_flag
3178: from pqh_attribute_ranges
3179: where attribute_id = p_attribute_id
3180: and position_id = p_position_id
3181: and routing_category_id = p_routing_category_id
3182: and nvl(delete_flag,'N') = 'N'

Line 3201: l_appr pqh_attribute_ranges.approver_flag%type;

3197: l_approver_flag boolean;
3198: l_override_approver boolean;
3199: --
3200: -- Added for Tar 4085705.996
3201: l_appr pqh_attribute_ranges.approver_flag%type;
3202: l_std_rule varchar2(10);
3203: --
3204: -- End of Added for Tar 4085705.996
3205: l_proc varchar2(256) := g_package||'ps_element_applicable';

Line 3402: from pqh_attribute_ranges

3398: p_applicable_flag out nocopy boolean,
3399: p_status_flag out nocopy number,
3400: p_can_approve out nocopy boolean) as
3401: cursor c1 is select distinct range_name, NVL(approver_flag,'N') approve_flag
3402: from pqh_attribute_ranges
3403: where routing_list_member_id = p_member_id
3404: and routing_category_id = p_routing_category_id
3405: and nvl(delete_flag,'N') = 'N'
3406: and nvl(enable_flag,'X') ='Y';

Line 3416: from pqh_attribute_ranges

3412: and tca.member_identifying_flag = 'Y'
3413: and nvl(att.enable_flag,'X') = 'Y';
3414: cursor c3(p_attribute_id number) is
3415: select range_name,from_char,to_char,from_date,to_date,from_number,to_number,approver_flag
3416: from pqh_attribute_ranges
3417: where attribute_id = p_attribute_id
3418: and routing_list_member_id = p_member_id
3419: and routing_category_id = p_routing_category_id
3420: and nvl(delete_flag,'N') = 'N'

Line 3898: procedure check_value_range(p_from_num in pqh_attribute_ranges.from_number%type,

3894: p_from_clause := null;
3895: raise;
3896: end prepare_from_clause;
3897:
3898: procedure check_value_range(p_from_num in pqh_attribute_ranges.from_number%type,
3899: p_to_num in pqh_attribute_ranges.to_number%type,
3900: p_value_num in pqh_attribute_ranges.to_number%type,
3901: p_in_range out nocopy boolean ,
3902: p_can_approve out nocopy boolean ) as

Line 3899: p_to_num in pqh_attribute_ranges.to_number%type,

3895: raise;
3896: end prepare_from_clause;
3897:
3898: procedure check_value_range(p_from_num in pqh_attribute_ranges.from_number%type,
3899: p_to_num in pqh_attribute_ranges.to_number%type,
3900: p_value_num in pqh_attribute_ranges.to_number%type,
3901: p_in_range out nocopy boolean ,
3902: p_can_approve out nocopy boolean ) as
3903: l_proc varchar2(256) := g_package||'check_value_range_num';

Line 3900: p_value_num in pqh_attribute_ranges.to_number%type,

3896: end prepare_from_clause;
3897:
3898: procedure check_value_range(p_from_num in pqh_attribute_ranges.from_number%type,
3899: p_to_num in pqh_attribute_ranges.to_number%type,
3900: p_value_num in pqh_attribute_ranges.to_number%type,
3901: p_in_range out nocopy boolean ,
3902: p_can_approve out nocopy boolean ) as
3903: l_proc varchar2(256) := g_package||'check_value_range_num';
3904: range_known exception;

Line 3979: procedure check_value_range (p_from_date in pqh_attribute_ranges.from_date%type,

3975: p_can_approve := null;
3976: raise;
3977: end check_value_range ;
3978:
3979: procedure check_value_range (p_from_date in pqh_attribute_ranges.from_date%type,
3980: p_to_date in pqh_attribute_ranges.to_date%type,
3981: p_value_date in pqh_attribute_ranges.to_date%type,
3982: p_in_range out nocopy boolean ,
3983: p_can_approve out nocopy boolean ) as

Line 3980: p_to_date in pqh_attribute_ranges.to_date%type,

3976: raise;
3977: end check_value_range ;
3978:
3979: procedure check_value_range (p_from_date in pqh_attribute_ranges.from_date%type,
3980: p_to_date in pqh_attribute_ranges.to_date%type,
3981: p_value_date in pqh_attribute_ranges.to_date%type,
3982: p_in_range out nocopy boolean ,
3983: p_can_approve out nocopy boolean ) as
3984: l_proc varchar2(256) := g_package||'check_value_range_date';

Line 3981: p_value_date in pqh_attribute_ranges.to_date%type,

3977: end check_value_range ;
3978:
3979: procedure check_value_range (p_from_date in pqh_attribute_ranges.from_date%type,
3980: p_to_date in pqh_attribute_ranges.to_date%type,
3981: p_value_date in pqh_attribute_ranges.to_date%type,
3982: p_in_range out nocopy boolean ,
3983: p_can_approve out nocopy boolean ) as
3984: l_proc varchar2(256) := g_package||'check_value_range_date';
3985: range_known exception;

Line 4055: procedure check_value_range (p_from_char in pqh_attribute_ranges.from_char%type,

4051: p_can_approve := null;
4052: raise;
4053: end check_value_range ;
4054:
4055: procedure check_value_range (p_from_char in pqh_attribute_ranges.from_char%type,
4056: p_to_char in pqh_attribute_ranges.to_char%type,
4057: p_value_char in pqh_attribute_ranges.to_char%type,
4058: p_in_range out nocopy boolean,
4059: p_can_approve out nocopy boolean ) as

Line 4056: p_to_char in pqh_attribute_ranges.to_char%type,

4052: raise;
4053: end check_value_range ;
4054:
4055: procedure check_value_range (p_from_char in pqh_attribute_ranges.from_char%type,
4056: p_to_char in pqh_attribute_ranges.to_char%type,
4057: p_value_char in pqh_attribute_ranges.to_char%type,
4058: p_in_range out nocopy boolean,
4059: p_can_approve out nocopy boolean ) as
4060: --Added l_from_char and l_to_char parms by deenath.

Line 4057: p_value_char in pqh_attribute_ranges.to_char%type,

4053: end check_value_range ;
4054:
4055: procedure check_value_range (p_from_char in pqh_attribute_ranges.from_char%type,
4056: p_to_char in pqh_attribute_ranges.to_char%type,
4057: p_value_char in pqh_attribute_ranges.to_char%type,
4058: p_in_range out nocopy boolean,
4059: p_can_approve out nocopy boolean ) as
4060: --Added l_from_char and l_to_char parms by deenath.
4061: l_from_char pqh_attribute_ranges.from_char%type;

Line 4061: l_from_char pqh_attribute_ranges.from_char%type;

4057: p_value_char in pqh_attribute_ranges.to_char%type,
4058: p_in_range out nocopy boolean,
4059: p_can_approve out nocopy boolean ) as
4060: --Added l_from_char and l_to_char parms by deenath.
4061: l_from_char pqh_attribute_ranges.from_char%type;
4062: l_to_char pqh_attribute_ranges.to_char%type;
4063: l_proc varchar2(256) := g_package||'check_value_range_char';
4064: range_known exception;
4065: begin

Line 4062: l_to_char pqh_attribute_ranges.to_char%type;

4058: p_in_range out nocopy boolean,
4059: p_can_approve out nocopy boolean ) as
4060: --Added l_from_char and l_to_char parms by deenath.
4061: l_from_char pqh_attribute_ranges.from_char%type;
4062: l_to_char pqh_attribute_ranges.to_char%type;
4063: l_proc varchar2(256) := g_package||'check_value_range_char';
4064: range_known exception;
4065: begin
4066: hr_utility.set_location('Entering '||l_proc,10);