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'
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'
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
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
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'
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'
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
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
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'
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'
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
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
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'
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'
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
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
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'
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'
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
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
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'
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'
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
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