11: -- Pre-reqs : None.
12: -- Parameters :
13: -- IN : p_api_version IN NUMBER Required
14: -- p_init_msg_list IN VARCHAR2 Optional
15: -- Default = FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Optional
17: -- Default = FND_API.G_FALSE
18: -- p_validation_level IN NUMBER Optional
19: -- Default = FND_API.G_VALID_LEVEL_FULL
13: -- IN : p_api_version IN NUMBER Required
14: -- p_init_msg_list IN VARCHAR2 Optional
15: -- Default = FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Optional
17: -- Default = FND_API.G_FALSE
18: -- p_validation_level IN NUMBER Optional
19: -- Default = FND_API.G_VALID_LEVEL_FULL
20: -- parameter1
21: -- parameter2
15: -- Default = FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Optional
17: -- Default = FND_API.G_FALSE
18: -- p_validation_level IN NUMBER Optional
19: -- Default = FND_API.G_VALID_LEVEL_FULL
20: -- parameter1
21: -- parameter2
22: -- .
23: -- .
41: -- rows through the QWB application.
42: --
43: PROCEDURE insert_row (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_plan_id IN NUMBER,
49: p_spec_id IN NUMBER DEFAULT NULL,
42: --
43: PROCEDURE insert_row (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_plan_id IN NUMBER,
49: p_spec_id IN NUMBER DEFAULT NULL,
50: p_org_id IN NUMBER,
43: PROCEDURE insert_row (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_plan_id IN NUMBER,
49: p_spec_id IN NUMBER DEFAULT NULL,
50: p_org_id IN NUMBER,
51: p_transaction_number IN NUMBER DEFAULT NULL,
74: -- rows through the QWB application.
75: --
76: PROCEDURE update_row (
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: p_plan_id IN NUMBER,
82: p_spec_id IN NUMBER DEFAULT NULL,
75: --
76: PROCEDURE update_row (
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: p_plan_id IN NUMBER,
82: p_spec_id IN NUMBER DEFAULT NULL,
83: p_org_id IN NUMBER,
76: PROCEDURE update_row (
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: p_plan_id IN NUMBER,
82: p_spec_id IN NUMBER DEFAULT NULL,
83: p_org_id IN NUMBER,
84: p_transaction_number IN NUMBER DEFAULT NULL,
102:
103:
104: PROCEDURE enable_and_fire_action (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_collection_id IN NUMBER,
110: x_return_status OUT NOCOPY VARCHAR2,
103:
104: PROCEDURE enable_and_fire_action (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_collection_id IN NUMBER,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
104: PROCEDURE enable_and_fire_action (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_collection_id IN NUMBER,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2);
113:
114:
115: PROCEDURE commit_qa_results (
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: p_collection_id IN NUMBER,
121: x_return_status OUT NOCOPY VARCHAR2,
114:
115: PROCEDURE commit_qa_results (
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: p_collection_id IN NUMBER,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
115: PROCEDURE commit_qa_results (
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: p_collection_id IN NUMBER,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2);