5: -- Declaration of Procedures and functions implementation
6: --===========================================================
7:
8: PROCEDURE Validate_Order(
9: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
10: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
11: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
12:
13: PROCEDURE Validate_Order_Header(
6: --===========================================================
7:
8: PROCEDURE Validate_Order(
9: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
10: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
11: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
12:
13: PROCEDURE Validate_Order_Header(
14: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
7:
8: PROCEDURE Validate_Order(
9: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
10: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
11: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
12:
13: PROCEDURE Validate_Order_Header(
14: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
15: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
10: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
11: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
12:
13: PROCEDURE Validate_Order_Header(
14: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
15: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
16: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
17:
18: PROCEDURE Populate_Order(
11: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
12:
13: PROCEDURE Validate_Order_Header(
14: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
15: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
16: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
17:
18: PROCEDURE Populate_Order(
19: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
12:
13: PROCEDURE Validate_Order_Header(
14: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
15: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
16: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
17:
18: PROCEDURE Populate_Order(
19: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
20: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
15: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
16: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
17:
18: PROCEDURE Populate_Order(
19: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
20: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
21: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
22: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
23:
16: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
17:
18: PROCEDURE Populate_Order(
19: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
20: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
21: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
22: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
23:
24: PROCEDURE Populate_Order_Header(
17:
18: PROCEDURE Populate_Order(
19: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
20: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
21: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
22: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
23:
24: PROCEDURE Populate_Order_Header(
25: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
18: PROCEDURE Populate_Order(
19: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
20: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
21: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
22: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
23:
24: PROCEDURE Populate_Order_Header(
25: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
26: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST
21: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
22: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
23:
24: PROCEDURE Populate_Order_Header(
25: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
26: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST
27: ) ;
28:
29: PROCEDURE VALIDATE_ORDER_LINE(
22: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
23:
24: PROCEDURE Populate_Order_Header(
25: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
26: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST
27: ) ;
28:
29: PROCEDURE VALIDATE_ORDER_LINE(
30: p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER,
26: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST
27: ) ;
28:
29: PROCEDURE VALIDATE_ORDER_LINE(
30: p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER,
31: p_service_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST);
32:
33: PROCEDURE POPULATE_ORDER_LINES(
34: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
27: ) ;
28:
29: PROCEDURE VALIDATE_ORDER_LINE(
30: p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER,
31: p_service_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST);
32:
33: PROCEDURE POPULATE_ORDER_LINES(
34: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
35: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
30: p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER,
31: p_service_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST);
32:
33: PROCEDURE POPULATE_ORDER_LINES(
34: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
35: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
36: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
37: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
38: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
31: p_service_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST);
32:
33: PROCEDURE POPULATE_ORDER_LINES(
34: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
35: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
36: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
37: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
38: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
39: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
32:
33: PROCEDURE POPULATE_ORDER_LINES(
34: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
35: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
36: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
37: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
38: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
39: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
40: );
33: PROCEDURE POPULATE_ORDER_LINES(
34: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
35: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
36: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
37: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
38: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
39: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
40: );
41:
34: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
35: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
36: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
37: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
38: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
39: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
40: );
41:
42: PROCEDURE CREATE_LINE_DETAILS(
35: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
36: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
37: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
38: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
39: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
40: );
41:
42: PROCEDURE CREATE_LINE_DETAILS(
43: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
39: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
40: );
41:
42: PROCEDURE CREATE_LINE_DETAILS(
43: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
44: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
45: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
46: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
47: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
40: );
41:
42: PROCEDURE CREATE_LINE_DETAILS(
43: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
44: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
45: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
46: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
47: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
48: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
41:
42: PROCEDURE CREATE_LINE_DETAILS(
43: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
44: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
45: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
46: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
47: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
48: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
49: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
42: PROCEDURE CREATE_LINE_DETAILS(
43: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
44: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
45: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
46: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
47: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
48: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
49: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
50: );
43: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
44: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
45: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
46: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
47: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
48: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
49: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
50: );
51:
44: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
45: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
46: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
47: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
48: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
49: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
50: );
51:
52: PROCEDURE Fetch_Line_details(p_line_item in XDP_TYPES.SERVICE_LINE_ITEM,
45: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
46: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
47: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
48: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
49: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
50: );
51:
52: PROCEDURE Fetch_Line_details(p_line_item in XDP_TYPES.SERVICE_LINE_ITEM,
53: p_line_parameter_list in XDP_TYPES.SERVICE_LINE_PARAM_LIST,
48: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
49: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
50: );
51:
52: PROCEDURE Fetch_Line_details(p_line_item in XDP_TYPES.SERVICE_LINE_ITEM,
53: p_line_parameter_list in XDP_TYPES.SERVICE_LINE_PARAM_LIST,
54: p_order_line_det_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
55: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
56:
49: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
50: );
51:
52: PROCEDURE Fetch_Line_details(p_line_item in XDP_TYPES.SERVICE_LINE_ITEM,
53: p_line_parameter_list in XDP_TYPES.SERVICE_LINE_PARAM_LIST,
54: p_order_line_det_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
55: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
56:
57: PROCEDURE EXPLODE_PACKAGE(
50: );
51:
52: PROCEDURE Fetch_Line_details(p_line_item in XDP_TYPES.SERVICE_LINE_ITEM,
53: p_line_parameter_list in XDP_TYPES.SERVICE_LINE_PARAM_LIST,
54: p_order_line_det_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
55: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
56:
57: PROCEDURE EXPLODE_PACKAGE(
58: P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
51:
52: PROCEDURE Fetch_Line_details(p_line_item in XDP_TYPES.SERVICE_LINE_ITEM,
53: p_line_parameter_list in XDP_TYPES.SERVICE_LINE_PARAM_LIST,
54: p_order_line_det_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
55: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
56:
57: PROCEDURE EXPLODE_PACKAGE(
58: P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
59: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
54: p_order_line_det_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
55: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
56:
57: PROCEDURE EXPLODE_PACKAGE(
58: P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
59: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
60: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
61: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
62: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
55: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
56:
57: PROCEDURE EXPLODE_PACKAGE(
58: P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
59: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
60: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
61: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
62: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
63: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
56:
57: PROCEDURE EXPLODE_PACKAGE(
58: P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
59: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
60: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
61: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
62: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
63: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
64: );
57: PROCEDURE EXPLODE_PACKAGE(
58: P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
59: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
60: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
61: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
62: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
63: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
64: );
65:
58: P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
59: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
60: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
61: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
62: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
63: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
64: );
65:
66: PROCEDURE EXPLODE_TXN_IB(
59: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
60: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
61: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
62: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
63: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
64: );
65:
66: PROCEDURE EXPLODE_TXN_IB(
67: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
63: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
64: );
65:
66: PROCEDURE EXPLODE_TXN_IB(
67: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
68: P_SERVICE_ORDER_LINE IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ITEM,
69: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
70: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
71: );
64: );
65:
66: PROCEDURE EXPLODE_TXN_IB(
67: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
68: P_SERVICE_ORDER_LINE IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ITEM,
69: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
70: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
71: );
72:
65:
66: PROCEDURE EXPLODE_TXN_IB(
67: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
68: P_SERVICE_ORDER_LINE IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ITEM,
69: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
70: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
71: );
72:
73: PROCEDURE IB_CSI_LINE(
66: PROCEDURE EXPLODE_TXN_IB(
67: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
68: P_SERVICE_ORDER_LINE IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ITEM,
69: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
70: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
71: );
72:
73: PROCEDURE IB_CSI_LINE(
74: P_SERVICE_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
70: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
71: );
72:
73: PROCEDURE IB_CSI_LINE(
74: P_SERVICE_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
75: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
76: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
77: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
78: );
71: );
72:
73: PROCEDURE IB_CSI_LINE(
74: P_SERVICE_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
75: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
76: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
77: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
78: );
79:
72:
73: PROCEDURE IB_CSI_LINE(
74: P_SERVICE_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
75: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
76: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
77: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
78: );
79:
80: PROCEDURE POPULATE_LINES(
73: PROCEDURE IB_CSI_LINE(
74: P_SERVICE_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
75: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
76: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
77: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
78: );
79:
80: PROCEDURE POPULATE_LINES(
81: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
77: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
78: );
79:
80: PROCEDURE POPULATE_LINES(
81: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
82: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
83: P_ORDER_LINE_REL_LIST IN XDP_TYPES.SERVICE_LINE_REL_LIST,
84: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
85: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
78: );
79:
80: PROCEDURE POPULATE_LINES(
81: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
82: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
83: P_ORDER_LINE_REL_LIST IN XDP_TYPES.SERVICE_LINE_REL_LIST,
84: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
85: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
86: );
79:
80: PROCEDURE POPULATE_LINES(
81: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
82: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
83: P_ORDER_LINE_REL_LIST IN XDP_TYPES.SERVICE_LINE_REL_LIST,
84: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
85: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
86: );
87:
80: PROCEDURE POPULATE_LINES(
81: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
82: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
83: P_ORDER_LINE_REL_LIST IN XDP_TYPES.SERVICE_LINE_REL_LIST,
84: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
85: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
86: );
87:
88: PROCEDURE POPULATE_FULFILL_WORKLIST_LIST(
81: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
82: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
83: P_ORDER_LINE_REL_LIST IN XDP_TYPES.SERVICE_LINE_REL_LIST,
84: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
85: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
86: );
87:
88: PROCEDURE POPULATE_FULFILL_WORKLIST_LIST(
89: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
85: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
86: );
87:
88: PROCEDURE POPULATE_FULFILL_WORKLIST_LIST(
89: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
90: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
91: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
92: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
93: );
86: );
87:
88: PROCEDURE POPULATE_FULFILL_WORKLIST_LIST(
89: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
90: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
91: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
92: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
93: );
94:
87:
88: PROCEDURE POPULATE_FULFILL_WORKLIST_LIST(
89: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
90: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
91: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
92: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
93: );
94:
95: PROCEDURE CREATE_FULFILL_WORKLIST(
88: PROCEDURE POPULATE_FULFILL_WORKLIST_LIST(
89: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
90: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
91: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
92: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
93: );
94:
95: PROCEDURE CREATE_FULFILL_WORKLIST(
96: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
92: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
93: );
94:
95: PROCEDURE CREATE_FULFILL_WORKLIST(
96: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
97: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
98: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
99: P_FULFILL_WORKLIST_LIST OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
100: );
93: );
94:
95: PROCEDURE CREATE_FULFILL_WORKLIST(
96: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
97: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
98: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
99: P_FULFILL_WORKLIST_LIST OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
100: );
101:
94:
95: PROCEDURE CREATE_FULFILL_WORKLIST(
96: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
97: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
98: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
99: P_FULFILL_WORKLIST_LIST OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
100: );
101:
102: PROCEDURE POPULATE_FULFILL_WORKLIST(
95: PROCEDURE CREATE_FULFILL_WORKLIST(
96: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
97: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
98: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
99: P_FULFILL_WORKLIST_LIST OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
100: );
101:
102: PROCEDURE POPULATE_FULFILL_WORKLIST(
103: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
99: P_FULFILL_WORKLIST_LIST OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
100: );
101:
102: PROCEDURE POPULATE_FULFILL_WORKLIST(
103: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
104: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST);
105:
106: PROCEDURE VALIDATE_WI_PARAM_CONFIG (
107: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
100: );
101:
102: PROCEDURE POPULATE_FULFILL_WORKLIST(
103: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
104: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST);
105:
106: PROCEDURE VALIDATE_WI_PARAM_CONFIG (
107: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
108: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
103: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
104: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST);
105:
106: PROCEDURE VALIDATE_WI_PARAM_CONFIG (
107: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
108: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
109: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
110: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
111: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
104: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST);
105:
106: PROCEDURE VALIDATE_WI_PARAM_CONFIG (
107: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
108: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
109: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
110: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
111: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
112: P_WORKITEM_EVAL_PARAM_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST );
105:
106: PROCEDURE VALIDATE_WI_PARAM_CONFIG (
107: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
108: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
109: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
110: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
111: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
112: P_WORKITEM_EVAL_PARAM_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST );
113:
106: PROCEDURE VALIDATE_WI_PARAM_CONFIG (
107: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
108: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
109: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
110: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
111: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
112: P_WORKITEM_EVAL_PARAM_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST );
113:
114: PROCEDURE POPULATE_WORKLIST_DETAILS (
107: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
108: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
109: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
110: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
111: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
112: P_WORKITEM_EVAL_PARAM_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST );
113:
114: PROCEDURE POPULATE_WORKLIST_DETAILS (
115: P_SERVICE_LINE_ATTRIB_LIST IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
108: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
109: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
110: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
111: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
112: P_WORKITEM_EVAL_PARAM_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST );
113:
114: PROCEDURE POPULATE_WORKLIST_DETAILS (
115: P_SERVICE_LINE_ATTRIB_LIST IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
116:
111: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
112: P_WORKITEM_EVAL_PARAM_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST );
113:
114: PROCEDURE POPULATE_WORKLIST_DETAILS (
115: P_SERVICE_LINE_ATTRIB_LIST IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
116:
117: PROCEDURE EVALUATE_WORKITEM_PARAMS(
118: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
119: P_WORKITEM_EVAL_PARAM_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
114: PROCEDURE POPULATE_WORKLIST_DETAILS (
115: P_SERVICE_LINE_ATTRIB_LIST IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
116:
117: PROCEDURE EVALUATE_WORKITEM_PARAMS(
118: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
119: P_WORKITEM_EVAL_PARAM_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
120:
121: PROCEDURE VALIDATE_LINE_ITEM (
122: P_ORGANIZATION_ID IN NUMBER ,
115: P_SERVICE_LINE_ATTRIB_LIST IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
116:
117: PROCEDURE EVALUATE_WORKITEM_PARAMS(
118: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
119: P_WORKITEM_EVAL_PARAM_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST);
120:
121: PROCEDURE VALIDATE_LINE_ITEM (
122: P_ORGANIZATION_ID IN NUMBER ,
123: P_ITEM_NUMBER IN OUT NOCOPY VARCHAR2,
132: ,X_ERROR_CODE OUT NOCOPY NUMBER
133: ,X_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
134:
135: PROCEDURE RUNTIME_VALIDATION(
136: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST
137: ,P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER);
138:
139:
140: FUNCTION VALIDATE_ORGANIZATION (
133: ,X_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
134:
135: PROCEDURE RUNTIME_VALIDATION(
136: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST
137: ,P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER);
138:
139:
140: FUNCTION VALIDATE_ORGANIZATION (
141: P_ORGANIZATION_ID IN NUMBER ,
606: -- a service activation order
607: -- Definition of Process_order API
608: --**************************************************
609: PROCEDURE Process_Order(
610: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
611: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
612: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
613: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
614: P_ORDER_ID OUT NOCOPY NUMBER,
607: -- Definition of Process_order API
608: --**************************************************
609: PROCEDURE Process_Order(
610: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
611: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
612: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
613: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
614: P_ORDER_ID OUT NOCOPY NUMBER,
615: RETURN_CODE OUT NOCOPY NUMBER,
608: --**************************************************
609: PROCEDURE Process_Order(
610: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
611: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
612: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
613: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
614: P_ORDER_ID OUT NOCOPY NUMBER,
615: RETURN_CODE OUT NOCOPY NUMBER,
616: ERROR_DESCRIPTION OUT NOCOPY VARCHAR2)
609: PROCEDURE Process_Order(
610: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
611: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
612: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
613: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
614: P_ORDER_ID OUT NOCOPY NUMBER,
615: RETURN_CODE OUT NOCOPY NUMBER,
616: ERROR_DESCRIPTION OUT NOCOPY VARCHAR2)
617: IS
752: --Definition of Procedure Validate_Order:-Calls Validate_Order_Header
753: --and Validate_Order_Lines
754: --===========================================================================
755: PROCEDURE Validate_Order(
756: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
757: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
758: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST)
759: IS
760: BEGIN
753: --and Validate_Order_Lines
754: --===========================================================================
755: PROCEDURE Validate_Order(
756: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
757: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
758: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST)
759: IS
760: BEGIN
761:
754: --===========================================================================
755: PROCEDURE Validate_Order(
756: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
757: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
758: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST)
759: IS
760: BEGIN
761:
762: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
812: --Note:- Order Id validation is checked during insert in XDP_ORDER_HEADERS
813: --************************************************************************
814:
815: PROCEDURE Validate_Order_Header(
816: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
817: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
818: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
819: )
820: IS
813: --************************************************************************
814:
815: PROCEDURE Validate_Order_Header(
816: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
817: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
818: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
819: )
820: IS
821: lv_cust_present VARCHAR2(1);
814:
815: PROCEDURE Validate_Order_Header(
816: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
817: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
818: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
819: )
820: IS
821: lv_cust_present VARCHAR2(1);
822: lv_mode VARCHAR2(8); -- maintenance mode profile
1050: -- validation procedure which checks if the services are valid
1051: --================================================================================
1052:
1053: PROCEDURE VALIDATE_ORDER_LINE
1054: (p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER,
1055: p_service_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST
1056: )
1057: IS
1058: lv_index NUMBER ;
1051: --================================================================================
1052:
1053: PROCEDURE VALIDATE_ORDER_LINE
1054: (p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER,
1055: p_service_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST
1056: )
1057: IS
1058: lv_index NUMBER ;
1059: lv_id NUMBER ;
1663: --and Populate Worklist Deatils
1664: --***********************************************************************
1665:
1666: PROCEDURE Populate_Order(
1667: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
1668: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
1669: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
1670: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
1671: )
1664: --***********************************************************************
1665:
1666: PROCEDURE Populate_Order(
1667: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
1668: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
1669: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
1670: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
1671: )
1672: IS
1665:
1666: PROCEDURE Populate_Order(
1667: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
1668: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
1669: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
1670: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
1671: )
1672: IS
1673: lv_service_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
1666: PROCEDURE Populate_Order(
1667: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
1668: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
1669: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
1670: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
1671: )
1672: IS
1673: lv_service_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
1674: lv_service_line_attrib_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1669: P_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
1670: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
1671: )
1672: IS
1673: lv_service_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
1674: lv_service_line_attrib_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1675: lv_service_line_rel_list XDP_TYPES.SERVICE_LINE_REL_LIST;
1676: lv_fulfill_worklist_list XDP_TYPES.FULFILL_WORKLIST_LIST;
1677: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
1670: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
1671: )
1672: IS
1673: lv_service_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
1674: lv_service_line_attrib_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1675: lv_service_line_rel_list XDP_TYPES.SERVICE_LINE_REL_LIST;
1676: lv_fulfill_worklist_list XDP_TYPES.FULFILL_WORKLIST_LIST;
1677: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
1678: lv_service_line_attrib_list1 XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1671: )
1672: IS
1673: lv_service_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
1674: lv_service_line_attrib_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1675: lv_service_line_rel_list XDP_TYPES.SERVICE_LINE_REL_LIST;
1676: lv_fulfill_worklist_list XDP_TYPES.FULFILL_WORKLIST_LIST;
1677: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
1678: lv_service_line_attrib_list1 XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1679: lv_workitem_eval_param_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1672: IS
1673: lv_service_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
1674: lv_service_line_attrib_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1675: lv_service_line_rel_list XDP_TYPES.SERVICE_LINE_REL_LIST;
1676: lv_fulfill_worklist_list XDP_TYPES.FULFILL_WORKLIST_LIST;
1677: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
1678: lv_service_line_attrib_list1 XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1679: lv_workitem_eval_param_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1680:
1673: lv_service_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
1674: lv_service_line_attrib_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1675: lv_service_line_rel_list XDP_TYPES.SERVICE_LINE_REL_LIST;
1676: lv_fulfill_worklist_list XDP_TYPES.FULFILL_WORKLIST_LIST;
1677: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
1678: lv_service_line_attrib_list1 XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1679: lv_workitem_eval_param_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1680:
1681: BEGIN
1674: lv_service_line_attrib_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1675: lv_service_line_rel_list XDP_TYPES.SERVICE_LINE_REL_LIST;
1676: lv_fulfill_worklist_list XDP_TYPES.FULFILL_WORKLIST_LIST;
1677: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
1678: lv_service_line_attrib_list1 XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1679: lv_workitem_eval_param_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1680:
1681: BEGIN
1682:
1675: lv_service_line_rel_list XDP_TYPES.SERVICE_LINE_REL_LIST;
1676: lv_fulfill_worklist_list XDP_TYPES.FULFILL_WORKLIST_LIST;
1677: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
1678: lv_service_line_attrib_list1 XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1679: lv_workitem_eval_param_list XDP_TYPES.SERVICE_LINE_ATTRIB_LIST;
1680:
1681: BEGIN
1682:
1683: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
1837: --**********************************************
1838: --Definition of Procedure Populate_Order_Header
1839: --***********************************************
1840: PROCEDURE Populate_Order_Header(
1841: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
1842: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST
1843: )
1844: IS
1845: -- Local Variables
1838: --Definition of Procedure Populate_Order_Header
1839: --***********************************************
1840: PROCEDURE Populate_Order_Header(
1841: P_ORDER_HEADER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
1842: P_ORDER_PARAMETER IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST
1843: )
1844: IS
1845: -- Local Variables
1846: lv_date DATE;
1850: lv_prov_required_flag varchar2(1);
1851: lv_org_id NUMBER;
1852: l_status_param_found BOOLEAN := FALSE ;
1853: l_result_param_found BOOLEAN := FALSE ;
1854: lv_name_tab XDP_TYPES.VARCHAR2_40_TAB;
1855: lv_val_tab XDP_TYPES.VARCHAR2_4000_TAB;
1856:
1857: -- Declare Exceptions
1858: e_order_num_duplicate EXCEPTION;
1851: lv_org_id NUMBER;
1852: l_status_param_found BOOLEAN := FALSE ;
1853: l_result_param_found BOOLEAN := FALSE ;
1854: lv_name_tab XDP_TYPES.VARCHAR2_40_TAB;
1855: lv_val_tab XDP_TYPES.VARCHAR2_4000_TAB;
1856:
1857: -- Declare Exceptions
1858: e_order_num_duplicate EXCEPTION;
1859:
2133: -- populate order lines
2134: -- ---------------------------------------------------------------------------
2135:
2136: PROCEDURE POPULATE_ORDER_LINES
2137: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
2138: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2139: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2140: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2141: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2134: -- ---------------------------------------------------------------------------
2135:
2136: PROCEDURE POPULATE_ORDER_LINES
2137: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
2138: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2139: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2140: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2141: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2142: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
2135:
2136: PROCEDURE POPULATE_ORDER_LINES
2137: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
2138: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2139: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2140: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2141: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2142: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
2143: ) IS
2136: PROCEDURE POPULATE_ORDER_LINES
2137: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
2138: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2139: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2140: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2141: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2142: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
2143: ) IS
2144:
2137: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
2138: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2139: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2140: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2141: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2142: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
2143: ) IS
2144:
2145: p_order_line_det_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;
2138: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2139: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2140: P_SERVICE_ORDER_LINE_LIST OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2141: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2142: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
2143: ) IS
2144:
2145: p_order_line_det_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;
2146: lv_param_index NUMBER;
2141: P_ORDER_LINE_REL_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2142: P_SERVICE_LINE_ATTRIB_LIST OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
2143: ) IS
2144:
2145: p_order_line_det_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;
2146: lv_param_index NUMBER;
2147: lv_line_index NUMBER ;
2148: l_line_number NUMBER;
2149: lv_line_exists_flag VARCHAR2(1);
2273: -- create line details
2274: -- ===========================================================================
2275:
2276: PROCEDURE CREATE_LINE_DETAILS
2277: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
2278: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2279: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2280: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2281: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2274: -- ===========================================================================
2275:
2276: PROCEDURE CREATE_LINE_DETAILS
2277: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
2278: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2279: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2280: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2281: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2282: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2275:
2276: PROCEDURE CREATE_LINE_DETAILS
2277: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
2278: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2279: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2280: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2281: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2282: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2283: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
2276: PROCEDURE CREATE_LINE_DETAILS
2277: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
2278: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2279: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2280: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2281: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2282: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2283: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
2284: ) IS
2277: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
2278: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2279: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2280: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2281: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2282: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2283: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
2284: ) IS
2285:
2278: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2279: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2280: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2281: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2282: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2283: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
2284: ) IS
2285:
2286: lv_index BINARY_INTEGER;
2279: P_LINE_PARAMETER_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2280: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2281: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2282: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2283: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
2284: ) IS
2285:
2286: lv_index BINARY_INTEGER;
2287: lv_temp NUMBER;
2289: l_max_line_num NUMBER;
2290: lv_max_line_num NUMBER;
2291: lv_temp_counter NUMBER := 0;
2292: l_line_item_id NUMBER;
2293: l_order_line_rec XDP_TYPES.LINE_ITEM;
2294: lv_fnd_count NUMBER := 0;
2295: l_param_exist VARCHAR2(5) :='FALSE';
2296: l_max NUMBER;
2297: l_param_line_list_counter NUMBER:=0;
2477: , SQLCODE
2478: , SQLERRM);
2479: END CREATE_LINE_DETAILS;
2480:
2481: Procedure Fetch_Line_details(p_line_item in XDP_TYPES.SERVICE_LINE_ITEM,
2482: p_line_parameter_list in XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2483: p_order_line_det_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2484: p_service_line_attrib_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST)
2485: is
2478: , SQLERRM);
2479: END CREATE_LINE_DETAILS;
2480:
2481: Procedure Fetch_Line_details(p_line_item in XDP_TYPES.SERVICE_LINE_ITEM,
2482: p_line_parameter_list in XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2483: p_order_line_det_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2484: p_service_line_attrib_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST)
2485: is
2486: lv_line_number number;
2479: END CREATE_LINE_DETAILS;
2480:
2481: Procedure Fetch_Line_details(p_line_item in XDP_TYPES.SERVICE_LINE_ITEM,
2482: p_line_parameter_list in XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2483: p_order_line_det_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2484: p_service_line_attrib_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST)
2485: is
2486: lv_line_number number;
2487: lv_line_id number;
2480:
2481: Procedure Fetch_Line_details(p_line_item in XDP_TYPES.SERVICE_LINE_ITEM,
2482: p_line_parameter_list in XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2483: p_order_line_det_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2484: p_service_line_attrib_list in OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST)
2485: is
2486: lv_line_number number;
2487: lv_line_id number;
2488: lv_count number;
2582: -- Procedure to explode Package and get Bill of Materials (Services)
2583: --================================================================================
2584:
2585: PROCEDURE EXPLODE_PACKAGE
2586: ( P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
2587: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2588: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2589: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2590: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2583: --================================================================================
2584:
2585: PROCEDURE EXPLODE_PACKAGE
2586: ( P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
2587: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2588: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2589: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2590: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2591: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
2584:
2585: PROCEDURE EXPLODE_PACKAGE
2586: ( P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
2587: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2588: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2589: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2590: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2591: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
2592: ) IS
2585: PROCEDURE EXPLODE_PACKAGE
2586: ( P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
2587: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2588: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2589: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2590: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2591: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
2592: ) IS
2593: lv_index1 NUMBER := 0 ;
2586: ( P_ORDER_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
2587: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2588: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2589: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2590: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2591: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
2592: ) IS
2593: lv_index1 NUMBER := 0 ;
2594: lv_index2 NUMBER := 0 ;
2587: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2588: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2589: P_LINE_PARAMETER_LIST_IN IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
2590: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
2591: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
2592: ) IS
2593: lv_index1 NUMBER := 0 ;
2594: lv_index2 NUMBER := 0 ;
2595: lv_index3 NUMBER := 0 ;
2799: -- ==============================================================================
2800:
2801:
2802: PROCEDURE EXPLODE_TXN_IB(
2803: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2804: P_SERVICE_ORDER_LINE IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ITEM,
2805: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2806: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
2807: ) IS
2800:
2801:
2802: PROCEDURE EXPLODE_TXN_IB(
2803: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2804: P_SERVICE_ORDER_LINE IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ITEM,
2805: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2806: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
2807: ) IS
2808:
2801:
2802: PROCEDURE EXPLODE_TXN_IB(
2803: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2804: P_SERVICE_ORDER_LINE IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ITEM,
2805: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2806: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
2807: ) IS
2808:
2809: lv_txn_line_query_rec CSI_T_DATASTRUCTURES_GRP.TXN_LINE_QUERY_REC;
2802: PROCEDURE EXPLODE_TXN_IB(
2803: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2804: P_SERVICE_ORDER_LINE IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ITEM,
2805: P_ORDER_LINE_REL_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_REL_LIST,
2806: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
2807: ) IS
2808:
2809: lv_txn_line_query_rec CSI_T_DATASTRUCTURES_GRP.TXN_LINE_QUERY_REC;
2810: lv_txn_line_detail_query_rec CSI_T_DATASTRUCTURES_GRP.TXN_LINE_DETAIL_QUERY_REC;
3319: -- ===================================================================================
3320:
3321:
3322: PROCEDURE IB_CSI_LINE(
3323: P_SERVICE_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
3324: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
3325: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3326: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
3327: )IS
3320:
3321:
3322: PROCEDURE IB_CSI_LINE(
3323: P_SERVICE_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
3324: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
3325: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3326: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
3327: )IS
3328: lv_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
3321:
3322: PROCEDURE IB_CSI_LINE(
3323: P_SERVICE_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
3324: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
3325: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3326: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
3327: )IS
3328: lv_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
3329: lv_ext_attribs_query_rec CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_QUERY_REC;
3322: PROCEDURE IB_CSI_LINE(
3323: P_SERVICE_LINE IN XDP_TYPES.SERVICE_LINE_ITEM,
3324: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
3325: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3326: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
3327: )IS
3328: lv_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
3329: lv_ext_attribs_query_rec CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_QUERY_REC;
3330: lv_extend_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
3751: -- populate XDP_ORDER_LINES, XDP_LINE_RELATIONSHIPS, XDP_ORDER_LINE_DETS
3752: -- ==========================================================================================
3753:
3754: PROCEDURE POPULATE_LINES
3755: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
3756: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
3757: P_ORDER_LINE_REL_LIST IN XDP_TYPES.SERVICE_LINE_REL_LIST,
3758: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3759: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
3752: -- ==========================================================================================
3753:
3754: PROCEDURE POPULATE_LINES
3755: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
3756: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
3757: P_ORDER_LINE_REL_LIST IN XDP_TYPES.SERVICE_LINE_REL_LIST,
3758: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3759: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
3760: ) IS
3753:
3754: PROCEDURE POPULATE_LINES
3755: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
3756: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
3757: P_ORDER_LINE_REL_LIST IN XDP_TYPES.SERVICE_LINE_REL_LIST,
3758: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3759: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
3760: ) IS
3761:
3754: PROCEDURE POPULATE_LINES
3755: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
3756: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
3757: P_ORDER_LINE_REL_LIST IN XDP_TYPES.SERVICE_LINE_REL_LIST,
3758: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3759: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
3760: ) IS
3761:
3762:
3755: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
3756: P_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
3757: P_ORDER_LINE_REL_LIST IN XDP_TYPES.SERVICE_LINE_REL_LIST,
3758: P_LINE_PARAMETER_LIST IN XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3759: P_ORDER_LINE_DET_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
3760: ) IS
3761:
3762:
3763:
4275: -- populate fulfill worklist
4276: -- ===========================================================================
4277:
4278: PROCEDURE POPULATE_FULFILL_WORKLIST_LIST
4279: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4280: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4281: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4282: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
4283: ) IS
4276: -- ===========================================================================
4277:
4278: PROCEDURE POPULATE_FULFILL_WORKLIST_LIST
4279: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4280: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4281: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4282: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
4283: ) IS
4284:
4277:
4278: PROCEDURE POPULATE_FULFILL_WORKLIST_LIST
4279: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4280: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4281: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4282: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
4283: ) IS
4284:
4285: -- REMOVE THIS!!!
4278: PROCEDURE POPULATE_FULFILL_WORKLIST_LIST
4279: (P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4280: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4281: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4282: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
4283: ) IS
4284:
4285: -- REMOVE THIS!!!
4286: -- p_fulfill_worklist XDP_TYPES.FULFILL_WORKLIST_LIST;
4282: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
4283: ) IS
4284:
4285: -- REMOVE THIS!!!
4286: -- p_fulfill_worklist XDP_TYPES.FULFILL_WORKLIST_LIST;
4287:
4288:
4289: BEGIN
4290:
4348: -- create fulfill worklist
4349: -- ==========================================================================
4350:
4351: PROCEDURE CREATE_FULFILL_WORKLIST (
4352: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4353: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4354: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4355: P_FULFILL_WORKLIST_LIST OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
4356: ) IS
4349: -- ==========================================================================
4350:
4351: PROCEDURE CREATE_FULFILL_WORKLIST (
4352: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4353: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4354: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4355: P_FULFILL_WORKLIST_LIST OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
4356: ) IS
4357:
4350:
4351: PROCEDURE CREATE_FULFILL_WORKLIST (
4352: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4353: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4354: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4355: P_FULFILL_WORKLIST_LIST OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
4356: ) IS
4357:
4358: lv_index BINARY_INTEGER;
4351: PROCEDURE CREATE_FULFILL_WORKLIST (
4352: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4353: P_SERVICE_ORDER_LINE_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4354: P_SERVICE_LINE_ATTRIB_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4355: P_FULFILL_WORKLIST_LIST OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST
4356: ) IS
4357:
4358: lv_index BINARY_INTEGER;
4359: lv_wi_index BINARY_INTEGER;
4694: -- ================================================================================
4695:
4696:
4697: PROCEDURE POPULATE_FULFILL_WORKLIST (
4698: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4699: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST) IS
4700:
4701: -- Index counter
4702: l_index NUMBER;
4695:
4696:
4697: PROCEDURE POPULATE_FULFILL_WORKLIST (
4698: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4699: P_FULFILL_WORKLIST_LIST IN OUT NOCOPY XDP_TYPES.FULFILL_WORKLIST_LIST) IS
4700:
4701: -- Index counter
4702: l_index NUMBER;
4703: lv_fnd_count NUMBER := 0;
4702: l_index NUMBER;
4703: lv_fnd_count NUMBER := 0;
4704:
4705: -- Table of primitives to handle FORALL insert
4706: l_workitem_instance_id XDP_TYPES.NUMBER_TAB;
4707: l_line_item_id xdp_types.number_tab;
4708: l_line_number xdp_types.number_tab;
4709: l_workitem_id xdp_types.number_tab;
4710: l_status_code xdp_types.varchar2_40_tab;
4703: lv_fnd_count NUMBER := 0;
4704:
4705: -- Table of primitives to handle FORALL insert
4706: l_workitem_instance_id XDP_TYPES.NUMBER_TAB;
4707: l_line_item_id xdp_types.number_tab;
4708: l_line_number xdp_types.number_tab;
4709: l_workitem_id xdp_types.number_tab;
4710: l_status_code xdp_types.varchar2_40_tab;
4711: l_provisioning_date xdp_types.date_tab;
4704:
4705: -- Table of primitives to handle FORALL insert
4706: l_workitem_instance_id XDP_TYPES.NUMBER_TAB;
4707: l_line_item_id xdp_types.number_tab;
4708: l_line_number xdp_types.number_tab;
4709: l_workitem_id xdp_types.number_tab;
4710: l_status_code xdp_types.varchar2_40_tab;
4711: l_provisioning_date xdp_types.date_tab;
4712: l_priority xdp_types.number_tab;
4705: -- Table of primitives to handle FORALL insert
4706: l_workitem_instance_id XDP_TYPES.NUMBER_TAB;
4707: l_line_item_id xdp_types.number_tab;
4708: l_line_number xdp_types.number_tab;
4709: l_workitem_id xdp_types.number_tab;
4710: l_status_code xdp_types.varchar2_40_tab;
4711: l_provisioning_date xdp_types.date_tab;
4712: l_priority xdp_types.number_tab;
4713: l_wi_sequence xdp_types.number_tab;
4706: l_workitem_instance_id XDP_TYPES.NUMBER_TAB;
4707: l_line_item_id xdp_types.number_tab;
4708: l_line_number xdp_types.number_tab;
4709: l_workitem_id xdp_types.number_tab;
4710: l_status_code xdp_types.varchar2_40_tab;
4711: l_provisioning_date xdp_types.date_tab;
4712: l_priority xdp_types.number_tab;
4713: l_wi_sequence xdp_types.number_tab;
4714: l_due_date xdp_types.date_tab;
4707: l_line_item_id xdp_types.number_tab;
4708: l_line_number xdp_types.number_tab;
4709: l_workitem_id xdp_types.number_tab;
4710: l_status_code xdp_types.varchar2_40_tab;
4711: l_provisioning_date xdp_types.date_tab;
4712: l_priority xdp_types.number_tab;
4713: l_wi_sequence xdp_types.number_tab;
4714: l_due_date xdp_types.date_tab;
4715: l_customer_required_date xdp_types.date_tab;
4708: l_line_number xdp_types.number_tab;
4709: l_workitem_id xdp_types.number_tab;
4710: l_status_code xdp_types.varchar2_40_tab;
4711: l_provisioning_date xdp_types.date_tab;
4712: l_priority xdp_types.number_tab;
4713: l_wi_sequence xdp_types.number_tab;
4714: l_due_date xdp_types.date_tab;
4715: l_customer_required_date xdp_types.date_tab;
4716:
4709: l_workitem_id xdp_types.number_tab;
4710: l_status_code xdp_types.varchar2_40_tab;
4711: l_provisioning_date xdp_types.date_tab;
4712: l_priority xdp_types.number_tab;
4713: l_wi_sequence xdp_types.number_tab;
4714: l_due_date xdp_types.date_tab;
4715: l_customer_required_date xdp_types.date_tab;
4716:
4717: TYPE VARCHAR2_30_TAB IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER ;
4710: l_status_code xdp_types.varchar2_40_tab;
4711: l_provisioning_date xdp_types.date_tab;
4712: l_priority xdp_types.number_tab;
4713: l_wi_sequence xdp_types.number_tab;
4714: l_due_date xdp_types.date_tab;
4715: l_customer_required_date xdp_types.date_tab;
4716:
4717: TYPE VARCHAR2_30_TAB IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER ;
4718:
4711: l_provisioning_date xdp_types.date_tab;
4712: l_priority xdp_types.number_tab;
4713: l_wi_sequence xdp_types.number_tab;
4714: l_due_date xdp_types.date_tab;
4715: l_customer_required_date xdp_types.date_tab;
4716:
4717: TYPE VARCHAR2_30_TAB IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER ;
4718:
4719: l_attribute_category_tab VARCHAR2_30_TAB;
4949: -- --------------------------------------------------------------------------------
4950: -- Validate Workitem Param Config
4951: -- --------------------------------------------------------------------------------
4952:
4953: PROCEDURE VALIDATE_WI_PARAM_CONFIG ( P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4954: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4955: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
4956: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4957: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4950: -- Validate Workitem Param Config
4951: -- --------------------------------------------------------------------------------
4952:
4953: PROCEDURE VALIDATE_WI_PARAM_CONFIG ( P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4954: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4955: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
4956: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4957: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4958: P_WORKITEM_EVAL_PARAM_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST) IS
4951: -- --------------------------------------------------------------------------------
4952:
4953: PROCEDURE VALIDATE_WI_PARAM_CONFIG ( P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4954: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4955: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
4956: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4957: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4958: P_WORKITEM_EVAL_PARAM_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST) IS
4959:
4952:
4953: PROCEDURE VALIDATE_WI_PARAM_CONFIG ( P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4954: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4955: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
4956: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4957: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4958: P_WORKITEM_EVAL_PARAM_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST) IS
4959:
4960: -- Cursor to get parameters defined for a WorkItem
4953: PROCEDURE VALIDATE_WI_PARAM_CONFIG ( P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
4954: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4955: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
4956: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4957: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4958: P_WORKITEM_EVAL_PARAM_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST) IS
4959:
4960: -- Cursor to get parameters defined for a WorkItem
4961: CURSOR lc_wi_param (l_wi_id NUMBER) IS
4954: P_SERVICE_ORDER_LINE_LIST IN XDP_TYPES.SERVICE_ORDER_LINE_LIST,
4955: P_FULFILL_WORKLIST_LIST IN XDP_TYPES.FULFILL_WORKLIST_LIST,
4956: P_SERVICE_LINE_ATTRIB_LIST_IN IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4957: P_SERVICE_LINE_ATTRIB_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST,
4958: P_WORKITEM_EVAL_PARAM_LIST_OUT OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST) IS
4959:
4960: -- Cursor to get parameters defined for a WorkItem
4961: CURSOR lc_wi_param (l_wi_id NUMBER) IS
4962: SELECT
5307:
5308:
5309:
5310: PROCEDURE POPULATE_WORKLIST_DETAILS (
5311: P_SERVICE_LINE_ATTRIB_LIST IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST) IS
5312:
5313: -- Table of primitives to handle FORALL insert
5314: l_workitem_instance_id XDP_TYPES.number_tab;
5315: l_workitem_id XDP_TYPES.number_tab;
5310: PROCEDURE POPULATE_WORKLIST_DETAILS (
5311: P_SERVICE_LINE_ATTRIB_LIST IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST) IS
5312:
5313: -- Table of primitives to handle FORALL insert
5314: l_workitem_instance_id XDP_TYPES.number_tab;
5315: l_workitem_id XDP_TYPES.number_tab;
5316: l_is_value_evaluated XDP_TYPES.varchar2_1_tab;
5317: l_parameter_value XDP_TYPES.varchar2_4000_tab;
5318: l_parameter_ref_value XDP_TYPES.varchar2_4000_tab;
5311: P_SERVICE_LINE_ATTRIB_LIST IN XDP_TYPES.SERVICE_LINE_ATTRIB_LIST) IS
5312:
5313: -- Table of primitives to handle FORALL insert
5314: l_workitem_instance_id XDP_TYPES.number_tab;
5315: l_workitem_id XDP_TYPES.number_tab;
5316: l_is_value_evaluated XDP_TYPES.varchar2_1_tab;
5317: l_parameter_value XDP_TYPES.varchar2_4000_tab;
5318: l_parameter_ref_value XDP_TYPES.varchar2_4000_tab;
5319: l_txn_attrib_detail_id XDP_TYPES.number_tab;
5312:
5313: -- Table of primitives to handle FORALL insert
5314: l_workitem_instance_id XDP_TYPES.number_tab;
5315: l_workitem_id XDP_TYPES.number_tab;
5316: l_is_value_evaluated XDP_TYPES.varchar2_1_tab;
5317: l_parameter_value XDP_TYPES.varchar2_4000_tab;
5318: l_parameter_ref_value XDP_TYPES.varchar2_4000_tab;
5319: l_txn_attrib_detail_id XDP_TYPES.number_tab;
5320: l_attrib_source_table XDP_TYPES.varchar2_30_tab;
5313: -- Table of primitives to handle FORALL insert
5314: l_workitem_instance_id XDP_TYPES.number_tab;
5315: l_workitem_id XDP_TYPES.number_tab;
5316: l_is_value_evaluated XDP_TYPES.varchar2_1_tab;
5317: l_parameter_value XDP_TYPES.varchar2_4000_tab;
5318: l_parameter_ref_value XDP_TYPES.varchar2_4000_tab;
5319: l_txn_attrib_detail_id XDP_TYPES.number_tab;
5320: l_attrib_source_table XDP_TYPES.varchar2_30_tab;
5321: l_attrib_source_id XDP_TYPES.number_tab;
5314: l_workitem_instance_id XDP_TYPES.number_tab;
5315: l_workitem_id XDP_TYPES.number_tab;
5316: l_is_value_evaluated XDP_TYPES.varchar2_1_tab;
5317: l_parameter_value XDP_TYPES.varchar2_4000_tab;
5318: l_parameter_ref_value XDP_TYPES.varchar2_4000_tab;
5319: l_txn_attrib_detail_id XDP_TYPES.number_tab;
5320: l_attrib_source_table XDP_TYPES.varchar2_30_tab;
5321: l_attrib_source_id XDP_TYPES.number_tab;
5322: l_modified_flag XDP_TYPES.varchar2_1_tab;
5315: l_workitem_id XDP_TYPES.number_tab;
5316: l_is_value_evaluated XDP_TYPES.varchar2_1_tab;
5317: l_parameter_value XDP_TYPES.varchar2_4000_tab;
5318: l_parameter_ref_value XDP_TYPES.varchar2_4000_tab;
5319: l_txn_attrib_detail_id XDP_TYPES.number_tab;
5320: l_attrib_source_table XDP_TYPES.varchar2_30_tab;
5321: l_attrib_source_id XDP_TYPES.number_tab;
5322: l_modified_flag XDP_TYPES.varchar2_1_tab;
5323: l_parameter_name XDP_TYPES.varchar2_40_tab;
5316: l_is_value_evaluated XDP_TYPES.varchar2_1_tab;
5317: l_parameter_value XDP_TYPES.varchar2_4000_tab;
5318: l_parameter_ref_value XDP_TYPES.varchar2_4000_tab;
5319: l_txn_attrib_detail_id XDP_TYPES.number_tab;
5320: l_attrib_source_table XDP_TYPES.varchar2_30_tab;
5321: l_attrib_source_id XDP_TYPES.number_tab;
5322: l_modified_flag XDP_TYPES.varchar2_1_tab;
5323: l_parameter_name XDP_TYPES.varchar2_40_tab;
5324:
5317: l_parameter_value XDP_TYPES.varchar2_4000_tab;
5318: l_parameter_ref_value XDP_TYPES.varchar2_4000_tab;
5319: l_txn_attrib_detail_id XDP_TYPES.number_tab;
5320: l_attrib_source_table XDP_TYPES.varchar2_30_tab;
5321: l_attrib_source_id XDP_TYPES.number_tab;
5322: l_modified_flag XDP_TYPES.varchar2_1_tab;
5323: l_parameter_name XDP_TYPES.varchar2_40_tab;
5324:
5325: -- Index counter
5318: l_parameter_ref_value XDP_TYPES.varchar2_4000_tab;
5319: l_txn_attrib_detail_id XDP_TYPES.number_tab;
5320: l_attrib_source_table XDP_TYPES.varchar2_30_tab;
5321: l_attrib_source_id XDP_TYPES.number_tab;
5322: l_modified_flag XDP_TYPES.varchar2_1_tab;
5323: l_parameter_name XDP_TYPES.varchar2_40_tab;
5324:
5325: -- Index counter
5326: l_index NUMBER;
5319: l_txn_attrib_detail_id XDP_TYPES.number_tab;
5320: l_attrib_source_table XDP_TYPES.varchar2_30_tab;
5321: l_attrib_source_id XDP_TYPES.number_tab;
5322: l_modified_flag XDP_TYPES.varchar2_1_tab;
5323: l_parameter_name XDP_TYPES.varchar2_40_tab;
5324:
5325: -- Index counter
5326: l_index NUMBER;
5327: lv_fnd_count NUMBER := 0;
5435: --------------------------------------
5436: -- EVALUATE WORKITEM PARMETER AND INSERT INTO XDP_WORKLIST DETAILS -- Added by sxbanerj -01/08/2001
5437: ---------------------------------------
5438: PROCEDURE EVALUATE_WORKITEM_PARAMS(
5439: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
5440: P_WORKITEM_EVAL_PARAM_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
5441: ) IS
5442:
5443: l_line_number NUMBER;
5436: -- EVALUATE WORKITEM PARMETER AND INSERT INTO XDP_WORKLIST DETAILS -- Added by sxbanerj -01/08/2001
5437: ---------------------------------------
5438: PROCEDURE EVALUATE_WORKITEM_PARAMS(
5439: P_ORDER_HEADER IN XDP_TYPES.SERVICE_ORDER_HEADER,
5440: P_WORKITEM_EVAL_PARAM_LIST IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ATTRIB_LIST
5441: ) IS
5442:
5443: l_line_number NUMBER;
5444: l_workitem VARCHAR2(80);
5557:
5558: --------------------------------------
5559: -- RUNTIME VALIDATION FOR WORKITEM --
5560: ---------------------------------------
5561: PROCEDURE RUNTIME_VALIDATION(p_fulfill_worklist_list IN XDP_TYPES.FULFILL_WORKLIST_LIST
5562: ,p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER) IS
5563:
5564: x_error_code NUMBER;
5565: x_error_message VARCHAR2(4000);
5558: --------------------------------------
5559: -- RUNTIME VALIDATION FOR WORKITEM --
5560: ---------------------------------------
5561: PROCEDURE RUNTIME_VALIDATION(p_fulfill_worklist_list IN XDP_TYPES.FULFILL_WORKLIST_LIST
5562: ,p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER) IS
5563:
5564: x_error_code NUMBER;
5565: x_error_message VARCHAR2(4000);
5566: lv_fnd_count NUMBER := 0;