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.PA_BILLING_SCHEDULE_UTILS dependencies on FND_API

Line 9: -- p_emp_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

5: -- Type : Public procedure
6: -- Pre-reqs : None
7: -- Return Value : N/A
8: -- Prameters
9: -- p_emp_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
10: -- p_emp_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
11: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
12: -- x_ emp_bill_rate_id OUT NUMBER REQUIRED
13: -- x_return_status OUT VARCHAR2 REQUIRED

Line 10: -- p_emp_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

6: -- Pre-reqs : None
7: -- Return Value : N/A
8: -- Prameters
9: -- p_emp_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
10: -- p_emp_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
11: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
12: -- x_ emp_bill_rate_id OUT NUMBER REQUIRED
13: -- x_return_status OUT VARCHAR2 REQUIRED
14: -- x_error_msg_code OUT VARCHAR2 REQUIRED

Line 23: p_emp_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

19: --
20: --
21:
22: PROCEDURE Emp_bill_rate_sch_name_To_Id(
23: p_emp_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
24: p_emp_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
25: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
26: x_emp_bill_rate_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 24: p_emp_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

20: --
21:
22: PROCEDURE Emp_bill_rate_sch_name_To_Id(
23: p_emp_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
24: p_emp_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
25: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
26: x_emp_bill_rate_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
27: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
28: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 36: -- p_job_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

32: -- Type : Public procedure
33: -- Pre-reqs : None
34: -- Return Value : N/A
35: -- Prameters
36: -- p_job_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
37: -- p_job_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
38: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
39: -- p_job_group_id IN NUMBER REQUIRED
40: -- x_job_bill_rate_id OUT NUMBER REQUIRED

Line 37: -- p_job_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

33: -- Pre-reqs : None
34: -- Return Value : N/A
35: -- Prameters
36: -- p_job_bill_rate_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
37: -- p_job_bill_rate_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
38: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
39: -- p_job_group_id IN NUMBER REQUIRED
40: -- x_job_bill_rate_id OUT NUMBER REQUIRED
41: -- x_return_status OUT VARCHAR2 REQUIRED

Line 51: p_job_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

47: --
48: --
49:
50: PROCEDURE job_bill_rate_sch_name_To_Id(
51: p_job_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
52: p_job_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
54: p_job_group_id IN NUMBER ,
55: x_job_bill_rate_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 52: p_job_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

48: --
49:
50: PROCEDURE job_bill_rate_sch_name_To_Id(
51: p_job_bill_rate_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
52: p_job_bill_rate_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
54: p_job_group_id IN NUMBER ,
55: x_job_bill_rate_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
56: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 65: -- p_rev_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

61: -- Type : Public procedure
62: -- Pre-reqs : None
63: -- Return Value : N/A
64: -- Prameters
65: -- p_rev_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
66: -- p_rev_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
67: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
68: -- x_rev_sch_id OUT NUMBER REQUIRED
69: -- x_return_status OUT VARCHAR2 REQUIRED

Line 66: -- p_rev_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

62: -- Pre-reqs : None
63: -- Return Value : N/A
64: -- Prameters
65: -- p_rev_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
66: -- p_rev_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
67: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
68: -- x_rev_sch_id OUT NUMBER REQUIRED
69: -- x_return_status OUT VARCHAR2 REQUIRED
70: -- x_error_msg_code OUT VARCHAR2 REQUIRED

Line 79: p_rev_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

75: --
76: --
77:
78: PROCEDURE Rev_Sch_Name_To_Id(
79: p_rev_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
80: p_rev_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
81: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
82: x_rev_sch_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
83: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 80: p_rev_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

76: --
77:
78: PROCEDURE Rev_Sch_Name_To_Id(
79: p_rev_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
80: p_rev_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
81: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
82: x_rev_sch_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
83: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
84: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 92: -- p_inv_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

88: -- Type : Public procedure
89: -- Pre-reqs : None
90: -- Return Value : N/A
91: -- Prameters
92: -- p_inv_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
93: -- p_inv_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
94: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
95: -- x_inv_sch_id OUT NUMBER REQUIRED
96: -- x_return_status OUT VARCHAR2 REQUIRED

Line 93: -- p_inv_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

89: -- Pre-reqs : None
90: -- Return Value : N/A
91: -- Prameters
92: -- p_inv_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
93: -- p_inv_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
94: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
95: -- x_inv_sch_id OUT NUMBER REQUIRED
96: -- x_return_status OUT VARCHAR2 REQUIRED
97: -- x_error_msg_code OUT VARCHAR2 REQUIRED

Line 106: p_Inv_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

102: --
103: --
104:
105: PROCEDURE Inv_Sch_Name_To_Id(
106: p_Inv_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
107: p_Inv_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
108: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
109: x_Inv_sch_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
110: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 107: p_Inv_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

103: --
104:
105: PROCEDURE Inv_Sch_Name_To_Id(
106: p_Inv_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
107: p_Inv_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
108: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
109: x_Inv_sch_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
110: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
111: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 119: -- p_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

115: -- Type : Public procedure
116: -- Pre-reqs : None
117: -- Return Value : N/A
118: -- Prameters
119: -- p_sch_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
120: -- p_nlbr_org_id IN NUMBER REQUIRED
121: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
122: -- x_sch_name OUT NUMBER REQUIRED
123: -- x_return_status OUT VARCHAR2 REQUIRED

Line 133: p_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

129: --
130: --
131:
132: PROCEDURE Nlbr_schedule_name_To_Id(
133: p_sch_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
134: p_nlbr_org_id IN NUMBER,
135: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
136: x_sch_name OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
137: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 146: -- p_org_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

142: -- Type : Public procedure
143: -- Pre-reqs : None
144: -- Return Value : N/A
145: -- Prameters
146: -- p_org_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
147: -- p_org_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
148: -- p_nlbr_org_id IN NUMBER REQUIRED
149: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
150: -- x_org_id OUT NUMBER REQUIRED

Line 147: -- p_org_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR

143: -- Pre-reqs : None
144: -- Return Value : N/A
145: -- Prameters
146: -- p_org_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
147: -- p_org_name IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_CHAR
148: -- p_nlbr_org_id IN NUMBER REQUIRED
149: -- p_check_id_flag IN VARCHAR2 REQUIRED DEFAULT 'A'
150: -- x_org_id OUT NUMBER REQUIRED
151: -- x_return_status OUT VARCHAR2 REQUIRED

Line 161: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

157: --
158: --
159:
160: PROCEDURE NL_org_sch_Name_To_Id(
161: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
162: p_org_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
163: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
164: x_org_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
165: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 162: p_org_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

158: --
159:
160: PROCEDURE NL_org_sch_Name_To_Id(
161: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
162: p_org_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
163: p_check_id_flag IN VARCHAR2 DEFAULT 'A',
164: x_org_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
165: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
166: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 175: -- p_task_id IN NUMBER OPTIONAL DEFAULT FND_API.MISS_NUM

171: -- Pre-reqs : None
172: -- Return Value : BOLLEAN
173: -- Prameters
174: -- p_project_id IN NUMBER REQUIRED
175: -- p_task_id IN NUMBER OPTIONAL DEFAULT FND_API.MISS_NUM
176: -- p_effective_from_date IN DATE REQUIRED
177: -- p_effective_to_date IN DATE
178: -- p_labor_multiplier_id IN NUMBER
179: -- x_return_status OUT VARCHAR2 REQUIRED

Line 189: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

185: --
186:
187: FUNCTION Duplicate_labor_Multiplier(
188: p_project_id IN NUMBER,
189: p_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
190: p_effective_from_date IN DATE ,
191: p_effective_to_date IN DATE ,
192: p_labor_multiplier_id IN NUMBER ,
193: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 201: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM

197: -- Type : Public procedure
198: -- Pre-reqs : None
199: -- Return Value : N/A
200: -- Prameters
201: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
202: -- p_job_bill_rate_sch_id IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_NUM
203: -- x_return_status OUT VARCHAR2 REQUIRED
204: -- x_error_msg_code OUT VARCHAR2 REQUIRED
205: --

Line 202: -- p_job_bill_rate_sch_id IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_NUM

198: -- Pre-reqs : None
199: -- Return Value : N/A
200: -- Prameters
201: -- p_emp_bill_rate_sch_id IN NUMBER OPTIONAL DEFAULT FND_API.G_MISS_NUM
202: -- p_job_bill_rate_sch_id IN VARCHAR2 OPTIONAL DEFAULT FND_API.G_MISS_NUM
203: -- x_return_status OUT VARCHAR2 REQUIRED
204: -- x_error_msg_code OUT VARCHAR2 REQUIRED
205: --
206: -- History

Line 213: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

209: --
210: --
211:
212: PROCEDURE Emp_job_mandatory_validation(
213: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
214: p_job_bill_rate_sch_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM,
215: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
216: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
217: );

Line 214: p_job_bill_rate_sch_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM,

210: --
211:
212: PROCEDURE Emp_job_mandatory_validation(
213: p_emp_bill_rate_sch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
214: p_job_bill_rate_sch_id IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM,
215: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
216: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
217: );
218: