eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_INTERFACES_PUB dependencies on XDP_TYPES

Line 15: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,

11: FND_API.G_VALID_LEVEL_FULL,
12: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,
15: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
16: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
17: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
18: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
19: x_SDP_ORDER_ID OUT NOCOPY NUMBER)

Line 16: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,

12: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,
15: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
16: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
17: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
18: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
19: x_SDP_ORDER_ID OUT NOCOPY NUMBER)
20: IS

Line 17: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,

13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,
15: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
16: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
17: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
18: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
19: x_SDP_ORDER_ID OUT NOCOPY NUMBER)
20: IS
21: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ORDER';

Line 18: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,

14: x_msg_data OUT NOCOPY VARCHAR2,
15: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
16: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
17: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
18: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
19: x_SDP_ORDER_ID OUT NOCOPY NUMBER)
20: IS
21: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ORDER';
22: l_api_version CONSTANT NUMBER := 11.5;

Line 25: lv_ORDER_HEADER XDP_TYPES.ORDER_HEADER;

21: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ORDER';
22: l_api_version CONSTANT NUMBER := 11.5;
23: lv_ret number;
24: lv_str varchar2(800);
25: lv_ORDER_HEADER XDP_TYPES.ORDER_HEADER;
26: lv_ORDER_PARAMETER XDP_TYPES.ORDER_PARAMETER_LIST;
27: lv_ORDER_LINE_LIST XDP_TYPES.ORDER_LINE_LIST;
28: lv_LINE_PARAMETER_LIST XDP_TYPES.LINE_PARAM_LIST;
29: lv_index binary_integer;

Line 26: lv_ORDER_PARAMETER XDP_TYPES.ORDER_PARAMETER_LIST;

22: l_api_version CONSTANT NUMBER := 11.5;
23: lv_ret number;
24: lv_str varchar2(800);
25: lv_ORDER_HEADER XDP_TYPES.ORDER_HEADER;
26: lv_ORDER_PARAMETER XDP_TYPES.ORDER_PARAMETER_LIST;
27: lv_ORDER_LINE_LIST XDP_TYPES.ORDER_LINE_LIST;
28: lv_LINE_PARAMETER_LIST XDP_TYPES.LINE_PARAM_LIST;
29: lv_index binary_integer;
30: lv_count number;

Line 27: lv_ORDER_LINE_LIST XDP_TYPES.ORDER_LINE_LIST;

23: lv_ret number;
24: lv_str varchar2(800);
25: lv_ORDER_HEADER XDP_TYPES.ORDER_HEADER;
26: lv_ORDER_PARAMETER XDP_TYPES.ORDER_PARAMETER_LIST;
27: lv_ORDER_LINE_LIST XDP_TYPES.ORDER_LINE_LIST;
28: lv_LINE_PARAMETER_LIST XDP_TYPES.LINE_PARAM_LIST;
29: lv_index binary_integer;
30: lv_count number;
31: lv_done varchar2(1);

Line 28: lv_LINE_PARAMETER_LIST XDP_TYPES.LINE_PARAM_LIST;

24: lv_str varchar2(800);
25: lv_ORDER_HEADER XDP_TYPES.ORDER_HEADER;
26: lv_ORDER_PARAMETER XDP_TYPES.ORDER_PARAMETER_LIST;
27: lv_ORDER_LINE_LIST XDP_TYPES.ORDER_LINE_LIST;
28: lv_LINE_PARAMETER_LIST XDP_TYPES.LINE_PARAM_LIST;
29: lv_index binary_integer;
30: lv_count number;
31: lv_done varchar2(1);
32: lv_proc varchar2(80);

Line 684: PROCEDURE TO_NULL(p_order_header IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER);

680: The following private procedures null all the gmiss fields
681: for their respective data structures.
682: */
683:
684: PROCEDURE TO_NULL(p_order_header IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER);
685: PROCEDURE TO_NULL(p_order_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST);
686: PROCEDURE TO_NULL(p_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST);
687: PROCEDURE TO_NULL(p_line_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
688:

Line 685: PROCEDURE TO_NULL(p_order_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST);

681: for their respective data structures.
682: */
683:
684: PROCEDURE TO_NULL(p_order_header IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER);
685: PROCEDURE TO_NULL(p_order_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST);
686: PROCEDURE TO_NULL(p_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST);
687: PROCEDURE TO_NULL(p_line_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
688:
689:

Line 686: PROCEDURE TO_NULL(p_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST);

682: */
683:
684: PROCEDURE TO_NULL(p_order_header IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER);
685: PROCEDURE TO_NULL(p_order_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST);
686: PROCEDURE TO_NULL(p_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST);
687: PROCEDURE TO_NULL(p_line_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
688:
689:
690: -- Process Order

Line 687: PROCEDURE TO_NULL(p_line_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);

683:
684: PROCEDURE TO_NULL(p_order_header IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER);
685: PROCEDURE TO_NULL(p_order_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST);
686: PROCEDURE TO_NULL(p_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST);
687: PROCEDURE TO_NULL(p_line_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST);
688:
689:
690: -- Process Order
691:

Line 701: p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER:= XDP_TYPES.G_MISS_SERVICE_ORDER_HEADER,

697: x_return_status OUT NOCOPY VARCHAR2,
698: x_msg_count OUT NOCOPY NUMBER,
699: x_msg_data OUT NOCOPY VARCHAR2,
700: x_error_code OUT NOCOPY VARCHAR2,
701: p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER:= XDP_TYPES.G_MISS_SERVICE_ORDER_HEADER,
702: p_order_param_list IN XDP_TYPES.SERVICE_ORDER_PARAM_LIST:= XDP_TYPES.G_MISS_ORDER_PARAM_LIST,
703: p_order_line_list IN XDP_TYPES.SERVICE_ORDER_LINE_LIST:= XDP_TYPES.G_MISS_SERVICE_ORDER_LINE_LIST,
704: p_line_param_list IN XDP_TYPES.SERVICE_LINE_PARAM_LIST:= XDP_TYPES.G_MISS_LINE_PARAM_LIST,
705: x_order_id OUT NOCOPY NUMBER

Line 702: p_order_param_list IN XDP_TYPES.SERVICE_ORDER_PARAM_LIST:= XDP_TYPES.G_MISS_ORDER_PARAM_LIST,

698: x_msg_count OUT NOCOPY NUMBER,
699: x_msg_data OUT NOCOPY VARCHAR2,
700: x_error_code OUT NOCOPY VARCHAR2,
701: p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER:= XDP_TYPES.G_MISS_SERVICE_ORDER_HEADER,
702: p_order_param_list IN XDP_TYPES.SERVICE_ORDER_PARAM_LIST:= XDP_TYPES.G_MISS_ORDER_PARAM_LIST,
703: p_order_line_list IN XDP_TYPES.SERVICE_ORDER_LINE_LIST:= XDP_TYPES.G_MISS_SERVICE_ORDER_LINE_LIST,
704: p_line_param_list IN XDP_TYPES.SERVICE_LINE_PARAM_LIST:= XDP_TYPES.G_MISS_LINE_PARAM_LIST,
705: x_order_id OUT NOCOPY NUMBER
706: )

Line 703: p_order_line_list IN XDP_TYPES.SERVICE_ORDER_LINE_LIST:= XDP_TYPES.G_MISS_SERVICE_ORDER_LINE_LIST,

699: x_msg_data OUT NOCOPY VARCHAR2,
700: x_error_code OUT NOCOPY VARCHAR2,
701: p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER:= XDP_TYPES.G_MISS_SERVICE_ORDER_HEADER,
702: p_order_param_list IN XDP_TYPES.SERVICE_ORDER_PARAM_LIST:= XDP_TYPES.G_MISS_ORDER_PARAM_LIST,
703: p_order_line_list IN XDP_TYPES.SERVICE_ORDER_LINE_LIST:= XDP_TYPES.G_MISS_SERVICE_ORDER_LINE_LIST,
704: p_line_param_list IN XDP_TYPES.SERVICE_LINE_PARAM_LIST:= XDP_TYPES.G_MISS_LINE_PARAM_LIST,
705: x_order_id OUT NOCOPY NUMBER
706: )
707: IS

Line 704: p_line_param_list IN XDP_TYPES.SERVICE_LINE_PARAM_LIST:= XDP_TYPES.G_MISS_LINE_PARAM_LIST,

700: x_error_code OUT NOCOPY VARCHAR2,
701: p_order_header IN XDP_TYPES.SERVICE_ORDER_HEADER:= XDP_TYPES.G_MISS_SERVICE_ORDER_HEADER,
702: p_order_param_list IN XDP_TYPES.SERVICE_ORDER_PARAM_LIST:= XDP_TYPES.G_MISS_ORDER_PARAM_LIST,
703: p_order_line_list IN XDP_TYPES.SERVICE_ORDER_LINE_LIST:= XDP_TYPES.G_MISS_SERVICE_ORDER_LINE_LIST,
704: p_line_param_list IN XDP_TYPES.SERVICE_LINE_PARAM_LIST:= XDP_TYPES.G_MISS_LINE_PARAM_LIST,
705: x_order_id OUT NOCOPY NUMBER
706: )
707: IS
708: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ORDER';

Line 725: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;

721: l_order_id NUMBER;
722: l_OAI_array JTF_USR_HKS.OAI_data_array_type ;
723: l_bind_data_id NUMBER;
724:
725: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
726: lv_order_param_list XDP_TYPES.SERVICE_ORDER_PARAM_LIST;
727: lv_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
728: lv_line_param_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;
729:

Line 726: lv_order_param_list XDP_TYPES.SERVICE_ORDER_PARAM_LIST;

722: l_OAI_array JTF_USR_HKS.OAI_data_array_type ;
723: l_bind_data_id NUMBER;
724:
725: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
726: lv_order_param_list XDP_TYPES.SERVICE_ORDER_PARAM_LIST;
727: lv_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
728: lv_line_param_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;
729:
730: BEGIN

Line 727: lv_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;

723: l_bind_data_id NUMBER;
724:
725: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
726: lv_order_param_list XDP_TYPES.SERVICE_ORDER_PARAM_LIST;
727: lv_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
728: lv_line_param_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;
729:
730: BEGIN
731: -- Standard call to check for call compatibility.

Line 728: lv_line_param_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;

724:
725: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
726: lv_order_param_list XDP_TYPES.SERVICE_ORDER_PARAM_LIST;
727: lv_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
728: lv_line_param_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;
729:
730: BEGIN
731: -- Standard call to check for call compatibility.
732:

Line 1245: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,

1241: x_error_code OUT NOCOPY VARCHAR2,
1242: p_order_number IN VARCHAR2,
1243: p_order_version IN VARCHAR2,
1244: p_order_id IN NUMBER,
1245: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
1246: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
1247: x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
1248: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
1249: )

Line 1246: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,

1242: p_order_number IN VARCHAR2,
1243: p_order_version IN VARCHAR2,
1244: p_order_id IN NUMBER,
1245: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
1246: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
1247: x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
1248: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
1249: )
1250: IS

Line 1247: x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,

1243: p_order_version IN VARCHAR2,
1244: p_order_id IN NUMBER,
1245: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
1246: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
1247: x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
1248: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
1249: )
1250: IS
1251: l_api_name CONSTANT VARCHAR2(30) := 'GET_ORDER_DETAILS';

Line 1248: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST

1244: p_order_id IN NUMBER,
1245: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
1246: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
1247: x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
1248: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST
1249: )
1250: IS
1251: l_api_name CONSTANT VARCHAR2(30) := 'GET_ORDER_DETAILS';
1252: l_api_version CONSTANT NUMBER := 11.5;

Line 1473: -- To retrieve order status as defined by XDP_TYPES.SERVICE_ORDER_STATUS

1469: x_msg_data := SQLERRM;
1470: END Get_Order_Details;
1471:
1472: --
1473: -- To retrieve order status as defined by XDP_TYPES.SERVICE_ORDER_STATUS
1474: --
1475: PROCEDURE Get_Order_Status(
1476: p_api_version IN NUMBER,
1477: p_init_msg_list IN VARCHAR2,

Line 1487: x_order_status OUT NOCOPY XDP_TYPES.SERVICE_ORDER_STATUS

1483: x_error_code OUT NOCOPY VARCHAR2,
1484: p_order_number IN VARCHAR2,
1485: p_order_version IN VARCHAR2,
1486: p_order_id IN NUMBER,
1487: x_order_status OUT NOCOPY XDP_TYPES.SERVICE_ORDER_STATUS
1488: )
1489: IS
1490: l_api_name CONSTANT VARCHAR2(30) := 'GET_ORDER_STATUS';
1491: l_api_version CONSTANT NUMBER := 11.5;

Line 1694: PROCEDURE TO_NULL(p_order_header IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER)

1690:
1691:
1692: --PRIVATE PROCEDURE , CONVERTING G_MISSES TO NULL
1693:
1694: PROCEDURE TO_NULL(p_order_header IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER)
1695: IS
1696: BEGIN
1697: IF p_order_header.order_number = FND_API.G_MISS_CHAR THEN
1698: p_order_header.order_number := NULL;

Line 1866: PROCEDURE TO_NULL(p_order_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST)

1862: p_order_header.execution_mode := 'ASYNC';
1863: END IF;
1864: END;
1865:
1866: PROCEDURE TO_NULL(p_order_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST)
1867: IS
1868: lv_param_index BINARY_INTEGER;
1869: BEGIN
1870: IF p_order_param_list.COUNT > 0 THEN

Line 1889: PROCEDURE TO_NULL(p_order_line_item IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ITEM)

1885: END LOOP;
1886: END IF;
1887: END;
1888:
1889: PROCEDURE TO_NULL(p_order_line_item IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_ITEM)
1890: IS
1891: BEGIN
1892: IF p_order_line_item.line_number = FND_API.G_MISS_NUM THEN
1893: p_order_line_item.line_number := NULL;

Line 2068: PROCEDURE TO_NULL(p_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST)

2064: p_order_line_item.is_virtual_line_flag := 'N';
2065: END IF;
2066: END;
2067:
2068: PROCEDURE TO_NULL(p_order_line_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST)
2069: IS
2070: lv_param_index BINARY_INTEGER;
2071: BEGIN
2072: IF p_order_line_list.COUNT > 0 THEN

Line 2082: PROCEDURE TO_NULL(p_line_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST)

2078: END LOOP;
2079: END IF;
2080: END;
2081:
2082: PROCEDURE TO_NULL(p_line_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST)
2083: IS
2084: lv_param_index BINARY_INTEGER;
2085: BEGIN
2086: IF p_line_param_list.COUNT > 0 THEN