3:
4: PROCEDURE Insert_Row
5: (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
4: PROCEDURE Insert_Row
5: (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
5: (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
13: p_row_id IN OUT NOCOPY VARCHAR2,
27:
28: PROCEDURE Lock_Row
29: (
30: p_api_version IN NUMBER,
31: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
32: p_commit IN VARCHAR2 := FND_API.G_FALSE,
33: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
28: PROCEDURE Lock_Row
29: (
30: p_api_version IN NUMBER,
31: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
32: p_commit IN VARCHAR2 := FND_API.G_FALSE,
33: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
29: (
30: p_api_version IN NUMBER,
31: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
32: p_commit IN VARCHAR2 := FND_API.G_FALSE,
33: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: p_row_id IN OUT NOCOPY VARCHAR2,
47:
48: PROCEDURE Update_Row
49: (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
48: PROCEDURE Update_Row
49: (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
49: (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_row_id IN OUT NOCOPY VARCHAR2,
69:
70: PROCEDURE Delete_Row
71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
70: PROCEDURE Delete_Row
71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
71: (
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_row_id IN VARCHAR2
82:
83: PROCEDURE Check_Unique
84: (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
83: PROCEDURE Check_Unique
84: (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
84: (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_row_id IN OUT NOCOPY VARCHAR2,
96:
97: PROCEDURE Create_Auto_CC_Num
98: (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
97: PROCEDURE Create_Auto_CC_Num
98: (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
98: (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: p_org_id IN igc_cc_headers.org_id%TYPE,
110:
111: PROCEDURE Validate_Numeric_CC_Num
112: (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
111: PROCEDURE Validate_Numeric_CC_Num
112: (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
112: (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_cc_num IN igc_cc_headers.cc_num%TYPE