[Home] [Help]
PACKAGE: APPS.PA_TOP_TASK_CUST_INVOICE_PVT
Source
1 PACKAGE PA_TOP_TASK_CUST_INVOICE_PVT AUTHID CURRENT_USER AS
2 /* $Header: PATOPCIS.pls 120.1 2005/08/19 17:04:44 mwasowic noship $ */
3
4 PROCEDURE enbl_disbl_cust_at_top_task(
5 p_api_version IN NUMBER := 1.0
6 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
7 , p_commit IN VARCHAR2 := FND_API.G_FALSE
8 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
9 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
10 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
11 , p_debug_mode IN VARCHAR2 := 'N'
12 , p_mode IN VARCHAR2
13 , p_project_id IN NUMBER
14 , p_def_top_task_cust IN NUMBER
15 , p_contr_update_cust IN NUMBER
16 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
17 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
18 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
19 );
20
21 PROCEDURE Get_Highest_Contr_Cust(
22 p_api_version IN NUMBER := 1.0
23 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
24 , p_commit IN VARCHAR2 := FND_API.G_FALSE
25 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
26 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
28 , p_debug_mode IN VARCHAR2 := 'N'
29 , p_project_id IN NUMBER
30 , p_exclude_cust_id_tbl IN PA_PLSQL_DATATYPES.NumTabTyp
31 , x_highst_contr_cust_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
32 , x_highst_contr_cust_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
33 , x_highst_contr_cust_num OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
34 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37 );
38
39 PROCEDURE Set_Rev_Acc_At_Top_Task(
40 p_api_version IN NUMBER := 1.0
41 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
42 , p_commit IN VARCHAR2 := FND_API.G_FALSE
43 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
44 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
45 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
46 , p_debug_mode IN VARCHAR2 := 'N'
47 , p_project_id IN NUMBER
48 , p_rev_acc IN VARCHAR2
49 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
51 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
52 );
53
54 PROCEDURE Set_Inv_Mth_At_Top_Task(
55 p_api_version IN NUMBER := 1.0
56 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
57 , p_commit IN VARCHAR2 := FND_API.G_FALSE
58 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
59 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
60 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
61 , p_debug_mode IN VARCHAR2 := 'N'
62 , p_project_id IN NUMBER
63 , p_inv_mth IN VARCHAR2
64 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
66 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67 );
68
69 PROCEDURE set_top_task_funding_level(
70 p_api_version IN NUMBER := 1.0
71 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
72 , p_commit IN VARCHAR2 := FND_API.G_FALSE
73 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
74 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
75 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
76 , p_debug_mode IN VARCHAR2 := 'N'
77 , p_project_id IN NUMBER
78 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
79 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
80 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
81 );
82
83 PROCEDURE check_delete_customer (
84 p_api_version IN NUMBER := 1.0
85 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
86 , p_commit IN VARCHAR2 := FND_API.G_FALSE
87 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
88 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
89 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
90 , p_debug_mode IN VARCHAR2 := 'N'
91 , p_project_id IN NUMBER
92 , p_customer_id IN NUMBER
93 , x_cust_assoc OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
94 , x_cust_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
95 , x_cust_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96 , x_cust_num OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
97 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
98 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
99 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
100 );
101
102 END PA_TOP_TASK_CUST_INVOICE_PVT;