10:
11:
12: PROCEDURE Validate_And_Write(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
18: p_header_id IN NUMBER := FND_API.G_MISS_NUM,
11:
12: PROCEDURE Validate_And_Write(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
18: p_header_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
12: PROCEDURE Validate_And_Write(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
18: p_header_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
20: p_creation_date IN DATE := FND_API.G_MISS_DATE,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
18: p_header_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
20: p_creation_date IN DATE := FND_API.G_MISS_DATE,
21: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
22: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
18: p_header_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
20: p_creation_date IN DATE := FND_API.G_MISS_DATE,
21: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
22: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
23: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
18: p_header_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
20: p_creation_date IN DATE := FND_API.G_MISS_DATE,
21: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
22: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
23: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
24: p_carrier IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
18: p_header_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
20: p_creation_date IN DATE := FND_API.G_MISS_DATE,
21: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
22: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
23: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
24: p_carrier IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_shipment_method IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: p_header_id IN NUMBER := FND_API.G_MISS_NUM,
19: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
20: p_creation_date IN DATE := FND_API.G_MISS_DATE,
21: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
22: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
23: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
24: p_carrier IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_shipment_method IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: p_autoreceipt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
20: p_creation_date IN DATE := FND_API.G_MISS_DATE,
21: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
22: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
23: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
24: p_carrier IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_shipment_method IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: p_autoreceipt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_creation_date IN DATE := FND_API.G_MISS_DATE,
21: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
22: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
23: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
24: p_carrier IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_shipment_method IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: p_autoreceipt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
22: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
23: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
24: p_carrier IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_shipment_method IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: p_autoreceipt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
23: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
24: p_carrier IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_shipment_method IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: p_autoreceipt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
24: p_carrier IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_shipment_method IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: p_autoreceipt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_carrier IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_shipment_method IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: p_autoreceipt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_shipment_method IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: p_autoreceipt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: p_autoreceipt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_location_id IN NUMBER := FND_API.G_MISS_NUM,
36: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_location_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_party_site_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
37: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_location_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_party_site_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
45: X_Return_Status OUT NOCOPY VARCHAR2,
38: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_location_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_party_site_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
45: X_Return_Status OUT NOCOPY VARCHAR2,
46: X_Msg_Count OUT NOCOPY NUMBER,
39: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_location_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_party_site_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
45: X_Return_Status OUT NOCOPY VARCHAR2,
46: X_Msg_Count OUT NOCOPY NUMBER,
47: X_Msg_Data OUT NOCOPY VARCHAR2
40: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_location_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_party_site_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
45: X_Return_Status OUT NOCOPY VARCHAR2,
46: X_Msg_Count OUT NOCOPY NUMBER,
47: X_Msg_Data OUT NOCOPY VARCHAR2
48: );