16: -- in PO_HEADERS_INTERFACE
17: -- * Parameters :
18: -- IN : p_api_version IN NUMBER Required
19: -- p_commit IN VARCHAR2 Optional
20: -- Default = FND_API.G_TRUE
21: -- p_init_msg_list IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Optional
24: -- Default = FND_API.G_VALID_LEVEL_FULL
18: -- IN : p_api_version IN NUMBER Required
19: -- p_commit IN VARCHAR2 Optional
20: -- Default = FND_API.G_TRUE
21: -- p_init_msg_list IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Optional
24: -- Default = FND_API.G_VALID_LEVEL_FULL
25: -- p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
26: -- Required
20: -- Default = FND_API.G_TRUE
21: -- p_init_msg_list IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Optional
24: -- Default = FND_API.G_VALID_LEVEL_FULL
25: -- p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
26: -- Required
27: -- Corresponds to the column INTERFACE_HEADER_ID in
28: -- the table PO_HEADERS_INTERFACE, and identifies the
37: --
38: -- End of comments
39: PROCEDURE updatePOHeaderId
40: ( p_api_version IN NUMBER ,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
44: x_return_status OUT NOCOPY VARCHAR2 ,
45: p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
38: -- End of comments
39: PROCEDURE updatePOHeaderId
40: ( p_api_version IN NUMBER ,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
44: x_return_status OUT NOCOPY VARCHAR2 ,
45: p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
46: );
39: PROCEDURE updatePOHeaderId
40: ( p_api_version IN NUMBER ,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
44: x_return_status OUT NOCOPY VARCHAR2 ,
45: p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
46: );
47:
55: -- in PO_LINES_INTERFACE
56: -- * Parameters :
57: -- IN : p_api_version IN NUMBER Required
58: -- p_commit IN VARCHAR2 Optional
59: -- Default = FND_API.G_TRUE
60: -- p_init_msg_list IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_validation_level IN NUMBER Optional
63: -- Default = FND_API.G_VALID_LEVEL_FULL
57: -- IN : p_api_version IN NUMBER Required
58: -- p_commit IN VARCHAR2 Optional
59: -- Default = FND_API.G_TRUE
60: -- p_init_msg_list IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_validation_level IN NUMBER Optional
63: -- Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
65: -- Required
59: -- Default = FND_API.G_TRUE
60: -- p_init_msg_list IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_validation_level IN NUMBER Optional
63: -- Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
65: -- Required
66: -- Corresponds to the column INTERFACE_LINE_ID in
67: -- the table PO_LINES_INTERFACE, and identifies the
76: --
77: -- End of comments
78: PROCEDURE updatePOLineId
79: ( p_api_version IN NUMBER ,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
82: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
83: x_return_status OUT NOCOPY VARCHAR2 ,
84: p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
77: -- End of comments
78: PROCEDURE updatePOLineId
79: ( p_api_version IN NUMBER ,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
82: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
83: x_return_status OUT NOCOPY VARCHAR2 ,
84: p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
85: );
78: PROCEDURE updatePOLineId
79: ( p_api_version IN NUMBER ,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
82: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
83: x_return_status OUT NOCOPY VARCHAR2 ,
84: p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
85: );
86:
91: -- * Function : inserts a job in icx_cat_r12_upgrade_jobs
92: -- * Parameters :
93: -- IN : p_api_version IN NUMBER Required
94: -- p_commit IN VARCHAR2 Optional
95: -- Default = FND_API.G_TRUE
96: -- p_init_msg_list IN VARCHAR2 Optional
97: -- Default = FND_API.G_FALSE
98: -- p_validation_level IN NUMBER Optional
99: -- Default = FND_API.G_VALID_LEVEL_FULL
93: -- IN : p_api_version IN NUMBER Required
94: -- p_commit IN VARCHAR2 Optional
95: -- Default = FND_API.G_TRUE
96: -- p_init_msg_list IN VARCHAR2 Optional
97: -- Default = FND_API.G_FALSE
98: -- p_validation_level IN NUMBER Optional
99: -- Default = FND_API.G_VALID_LEVEL_FULL
100: -- p_job_type IN VARCHAR2 Required
101: -- Type of job to be created
95: -- Default = FND_API.G_TRUE
96: -- p_init_msg_list IN VARCHAR2 Optional
97: -- Default = FND_API.G_FALSE
98: -- p_validation_level IN NUMBER Optional
99: -- Default = FND_API.G_VALID_LEVEL_FULL
100: -- p_job_type IN VARCHAR2 Required
101: -- Type of job to be created
102: -- p_audsid IN NUMBER Required
103: -- audsid for the job to be created
110: --
111: -- End of comments
112: PROCEDURE createR12UpgradeJob
113: ( p_api_version IN NUMBER ,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
116: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
117: x_return_status OUT NOCOPY VARCHAR2 ,
118: p_job_type IN VARCHAR2,
111: -- End of comments
112: PROCEDURE createR12UpgradeJob
113: ( p_api_version IN NUMBER ,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
116: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
117: x_return_status OUT NOCOPY VARCHAR2 ,
118: p_job_type IN VARCHAR2,
119: p_audsid IN NUMBER
112: PROCEDURE createR12UpgradeJob
113: ( p_api_version IN NUMBER ,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
116: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
117: x_return_status OUT NOCOPY VARCHAR2 ,
118: p_job_type IN VARCHAR2,
119: p_audsid IN NUMBER
120: );
126: -- * Function : updates a job in icx_cat_r12_upgrade_jobs
127: -- * Parameters :
128: -- IN : p_api_version IN NUMBER Required
129: -- p_commit IN VARCHAR2 Optional
130: -- Default = FND_API.G_TRUE
131: -- p_init_msg_list IN VARCHAR2 Optional
132: -- Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional
134: -- Default = FND_API.G_VALID_LEVEL_FULL
128: -- IN : p_api_version IN NUMBER Required
129: -- p_commit IN VARCHAR2 Optional
130: -- Default = FND_API.G_TRUE
131: -- p_init_msg_list IN VARCHAR2 Optional
132: -- Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional
134: -- Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_job_status IN VARCHAR2 Required
136: -- New status of the job
130: -- Default = FND_API.G_TRUE
131: -- p_init_msg_list IN VARCHAR2 Optional
132: -- Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional
134: -- Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_job_status IN VARCHAR2 Required
136: -- New status of the job
137: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
138: -- * Version : Current version 1.0
143: --
144: -- End of comments
145: PROCEDURE updateR12UpgradeJob
146: ( p_api_version IN NUMBER ,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
149: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
150: x_return_status OUT NOCOPY VARCHAR2 ,
151: p_job_status IN VARCHAR2
144: -- End of comments
145: PROCEDURE updateR12UpgradeJob
146: ( p_api_version IN NUMBER ,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
149: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
150: x_return_status OUT NOCOPY VARCHAR2 ,
151: p_job_status IN VARCHAR2
152: );
145: PROCEDURE updateR12UpgradeJob
146: ( p_api_version IN NUMBER ,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
149: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL ,
150: x_return_status OUT NOCOPY VARCHAR2 ,
151: p_job_status IN VARCHAR2
152: );
153: