APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on XMLTYPE

Line 23: TABLE(XMLSequence(extract(cr.file_content_xmltype,'/OIC_PLAN_COPY'))) v

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
27: SELECT COUNT(extract(value(v),'/CnCompPlansVO'))

Line 29: TABLE(XMLSequence(extract(cr.file_content_xmltype,'/OIC_PLAN_COPY/CnCompPlansVO'))) v

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;
33: v_xml cn_copy_requests_all.file_content_xmltype%TYPE;

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 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 67: -- Calling Common Utility Package for conversion to CLOB and XMLType

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,
70: p_init_msg_list => FND_API.G_FALSE,
71: p_commit => FND_API.G_FALSE,

Line 68: cn_plancopy_util_pvt.convert_blob_to_xmltype (

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,
70: p_init_msg_list => FND_API.G_FALSE,
71: p_commit => FND_API.G_FALSE,
72: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 83: -- Fetching XML from XMLType.

79: ELSE
80: RAISE fnd_api.g_exc_unexpected_error;
81: END IF;
82:
83: -- Fetching XML from XMLType.
84: OPEN oic_plan_copy;
85: FETCH oic_plan_copy INTO v_xml;
86: CLOSE oic_plan_copy;
87:

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,