1 PACKAGE PA_CC_TP_UTILS AS
2 /* $Header: PAXTPUTS.pls 120.2 2005/08/08 04:27:35 rgandhi noship $ */
3
4 G_business_group_id number := fnd_profile.value('PER_BUSINESS_GROUP_ID'); /* Changed for Shared Services*/
5 G_global_access varchar2(1) :=nvl(pa_cross_business_grp.IsCrossBGProfile,'N');
6 ------------------------------------------------------------------------
7 --- is_rule_in_schedule_lines_
8 -----This function returns 'Y' if the transfer price rule is used in
9 -----transfer price schedule lines
10 ------------------------------------------------------------------------
11 FUNCTION is_rule_in_schedule_lines (p_rule_id IN NUMBER)
12 RETURN varchar2 ;
13 --PRAGMA RESTRICT_REFERENCES(is_rule_in_schedule_lines, WNDS, WNPS) ;
14
15 function get_lowest_org_level(p_organization_id in number)
16 return varchar2;
17 --PRAGMA RESTRICT_REFERENCES(get_lowest_org_level, WNDS, WNPS) ;
18
19 function get_highest_org_level(p_organization_id in number)
20 return varchar2;
21 --PRAGMA RESTRICT_REFERENCES(get_highest_org_level, WNDS, WNPS) ;
22
23
24 procedure pre_insert_schedule_lines(p_tp_schedule_id IN number,
25 p_prvdr_organization_id IN number,
26 p_recvr_organization_id in number);
27
28 procedure pre_delete_schedule_lines(p_tp_schedule_id in number,
29 p_tp_schedule_line_id in number);
30
31 procedure check_delete_tp_schedule_ok(p_tp_schedule_id in number,
32 x_error_code in out NOCOPY number,/*File.sql.39*/
33 x_error_stage in out NOCOPY varchar2,/*File.sql.39*/
34 x_error_stack in out NOCOPY varchar2 /*File.sql.39*/);
35 procedure check_del_update_rule_ok(p_tp_rule_id in number,
36 x_error_code in out NOCOPY number,/*File.sql.39*/
37 x_error_stage in out NOCOPY varchar2,/*File.sql.39*/
38 x_error_stack in out NOCOPY varchar2);/*File.sql.39*/
39
40 END PA_CC_TP_UTILS;