APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_COPY_REQUESTS_ALL

Line 18: p_exp_imp_request_id IN cn_copy_requests_all.exp_imp_request_id%TYPE) IS

14: /***************************************************************************/
15: PROCEDURE Import_PlanCopy
16: (errbuf OUT NOCOPY VARCHAR2,
17: retcode OUT NOCOPY NUMBER,
18: p_exp_imp_request_id IN cn_copy_requests_all.exp_imp_request_id%TYPE) IS
19:
20: CURSOR oic_plan_copy IS
21: SELECT extract(value(v),'/OIC_PLAN_COPY') "CP"
22: FROM cn_copy_requests_all cr,

Line 22: FROM cn_copy_requests_all cr,

18: p_exp_imp_request_id IN cn_copy_requests_all.exp_imp_request_id%TYPE) IS
19:
20: CURSOR oic_plan_copy IS
21: SELECT extract(value(v),'/OIC_PLAN_COPY') "CP"
22: FROM cn_copy_requests_all cr,
23: TABLE(XMLSequence(extract(cr.file_content_xmltype,'/OIC_PLAN_COPY'))) v
24: WHERE cr.exp_imp_request_id = p_exp_imp_request_id;
25:
26: CURSOR oic_object_count IS

Line 28: FROM cn_copy_requests_all cr,

24: WHERE cr.exp_imp_request_id = p_exp_imp_request_id;
25:
26: CURSOR oic_object_count IS
27: SELECT COUNT(extract(value(v),'/CnCompPlansVO'))
28: FROM cn_copy_requests_all cr,
29: TABLE(XMLSequence(extract(cr.file_content_xmltype,'/OIC_PLAN_COPY/CnCompPlansVO'))) v
30: WHERE cr.exp_imp_request_id = p_exp_imp_request_id;
31:
32: v_prefix cn_copy_requests_all.prefix_info%TYPE;

Line 32: v_prefix cn_copy_requests_all.prefix_info%TYPE;

28: FROM cn_copy_requests_all cr,
29: TABLE(XMLSequence(extract(cr.file_content_xmltype,'/OIC_PLAN_COPY/CnCompPlansVO'))) v
30: WHERE cr.exp_imp_request_id = p_exp_imp_request_id;
31:
32: v_prefix cn_copy_requests_all.prefix_info%TYPE;
33: v_xml cn_copy_requests_all.file_content_xmltype%TYPE;
34: v_org_id cn_copy_requests_all.org_id%TYPE;
35: v_object_count NUMBER;
36: v_start_date DATE;

Line 33: v_xml cn_copy_requests_all.file_content_xmltype%TYPE;

29: TABLE(XMLSequence(extract(cr.file_content_xmltype,'/OIC_PLAN_COPY/CnCompPlansVO'))) v
30: WHERE cr.exp_imp_request_id = p_exp_imp_request_id;
31:
32: v_prefix cn_copy_requests_all.prefix_info%TYPE;
33: v_xml cn_copy_requests_all.file_content_xmltype%TYPE;
34: v_org_id cn_copy_requests_all.org_id%TYPE;
35: v_object_count NUMBER;
36: v_start_date DATE;
37: v_end_date DATE;

Line 34: v_org_id cn_copy_requests_all.org_id%TYPE;

30: WHERE cr.exp_imp_request_id = p_exp_imp_request_id;
31:
32: v_prefix cn_copy_requests_all.prefix_info%TYPE;
33: v_xml cn_copy_requests_all.file_content_xmltype%TYPE;
34: v_org_id cn_copy_requests_all.org_id%TYPE;
35: v_object_count NUMBER;
36: v_start_date DATE;
37: v_end_date DATE;
38: l_msgs VARCHAR2(2000);

Line 57: FROM cn_copy_requests_all

53: retcode := 0;
54:
55: -- Get Prefix and Date Information
56: SELECT prefix_info, change_start_date, change_end_date, org_id INTO v_prefix, v_start_date, v_end_date, v_org_id
57: FROM cn_copy_requests_all
58: WHERE exp_imp_request_id = p_exp_imp_request_id;
59:
60: -- Check if OrgId is not set
61: IF v_org_id IS NULL THEN

Line 65: -- Populating CLOB and XMLType Columns of cn_copy_requests_all

61: IF v_org_id IS NULL THEN
62: RAISE fnd_api.g_exc_unexpected_error;
63: END IF;
64:
65: -- Populating CLOB and XMLType Columns of cn_copy_requests_all
66: -- Plan Copy Import Request only populates the BLOB column.
67: -- Calling Common Utility Package for conversion to CLOB and XMLType
68: cn_plancopy_util_pvt.convert_blob_to_xmltype (
69: p_api_version => 1.0,

Line 108: UPDATE cn_copy_requests_all

104: x_import_status => x_import_status);
105:
106: -- Update the status of Import Process
107: IF x_import_status = 'COMPLETED' THEN
108: UPDATE cn_copy_requests_all
109: SET status_code = 'COMPLETED',
110: completion_date = SYSDATE
111: WHERE exp_imp_request_id = p_exp_imp_request_id;
112: COMMIT;

Line 114: UPDATE cn_copy_requests_all

110: completion_date = SYSDATE
111: WHERE exp_imp_request_id = p_exp_imp_request_id;
112: COMMIT;
113: ELSE
114: UPDATE cn_copy_requests_all
115: SET status_code = 'FAILED',
116: completion_date = SYSDATE
117: WHERE exp_imp_request_id = p_exp_imp_request_id;
118: COMMIT;

Line 126: UPDATE cn_copy_requests_all

122: WHEN fnd_api.g_exc_unexpected_error THEN
123: ROLLBACK TO Import_PlanCopy;
124: retcode := 2;
125: errbuf := SQLCODE||' '||Sqlerrm;
126: UPDATE cn_copy_requests_all
127: SET status_code = 'FAILED',
128: completion_date = SYSDATE
129: WHERE exp_imp_request_id = p_exp_imp_request_id;
130: COMMIT;

Line 134: UPDATE cn_copy_requests_all

130: COMMIT;
131: WHEN OTHERS THEN
132: retcode := 2;
133: errbuf := SQLCODE||' '||Sqlerrm;
134: UPDATE cn_copy_requests_all
135: SET status_code = 'FAILED',
136: completion_date = SYSDATE
137: WHERE exp_imp_request_id = p_exp_imp_request_id;
138: COMMIT;

Line 155: p_xml IN cn_copy_requests_all.file_content_xmltype%TYPE,

151: (p_api_version IN NUMBER := 1.0,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: p_xml IN cn_copy_requests_all.file_content_xmltype%TYPE,
156: p_prefix IN cn_copy_requests_all.prefix_info%TYPE,
157: p_start_date IN DATE,
158: p_end_date IN DATE,
159: p_org_id IN cn_copy_requests_all.org_id%TYPE,

Line 156: p_prefix IN cn_copy_requests_all.prefix_info%TYPE,

152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: p_xml IN cn_copy_requests_all.file_content_xmltype%TYPE,
156: p_prefix IN cn_copy_requests_all.prefix_info%TYPE,
157: p_start_date IN DATE,
158: p_end_date IN DATE,
159: p_org_id IN cn_copy_requests_all.org_id%TYPE,
160: p_object_count IN NUMBER,

Line 159: p_org_id IN cn_copy_requests_all.org_id%TYPE,

155: p_xml IN cn_copy_requests_all.file_content_xmltype%TYPE,
156: p_prefix IN cn_copy_requests_all.prefix_info%TYPE,
157: p_start_date IN DATE,
158: p_end_date IN DATE,
159: p_org_id IN cn_copy_requests_all.org_id%TYPE,
160: p_object_count IN NUMBER,
161: x_import_status OUT NOCOPY VARCHAR2)IS
162:
163: -- Table Record Declaration