DBA Data[Home] [Help]

APPS.XDP_ENGINE dependencies on XDP_TYPES

Line 1322: RETURN XDP_TYPES.ORDER_PARAMETER_LIST

1318: for a given fulfillment element
1319: */
1320: FUNCTION Get_FE_AttributeVal_List(
1321: p_fe_name in varchar2)
1322: RETURN XDP_TYPES.ORDER_PARAMETER_LIST
1323: IS
1324: lv_attrVal varchar2(4000);
1325: lv_fe_id NUMBER;
1326: lv_fetype_id NUMBER;

Line 1332: lv_attr_list XDP_TYPES.ORDER_PARAMETER_LIST;

1328: lv_fe_sw_generic varchar2(40);
1329: lv_adapter_type varchar2(40);
1330: lv_conceal_data VARCHAR2(10);
1331: lv_gen_lookup_id number;
1332: lv_attr_list XDP_TYPES.ORDER_PARAMETER_LIST;
1333: lv_index number := 0;
1334:
1335: lv_dummyvar varchar2(80);
1336:

Line 1391: RETURN XDP_TYPES.ORDER_PARAMETER_LIST

1387: for a given fulfillment element
1388: */
1389: FUNCTION Get_FE_AttributeVal_List(
1390: p_fe_id in number)
1391: RETURN XDP_TYPES.ORDER_PARAMETER_LIST
1392: IS
1393: lv_attrVal varchar2(4000);
1394: lv_fe_name varchar2(80);
1395: lv_fetype_id NUMBER;

Line 1401: lv_attr_list XDP_TYPES.ORDER_PARAMETER_LIST;

1397: lv_fe_sw_generic varchar2(40);
1398: lv_adapter_type varchar2(40);
1399: lv_conceal_data VARCHAR2(10);
1400: lv_gen_lookup_id number;
1401: lv_attr_list XDP_TYPES.ORDER_PARAMETER_LIST;
1402: lv_index number := 0;
1403:
1404: lv_dummyvar varchar2(80);
1405:

Line 1583: return XDP_TYPES.WORKITEM_LIST

1579: Retrieve the list of the workitems SFM has executed for the given order.
1580: */
1581: Function Get_Workitem_List(
1582: p_sdp_order_id NUMBER)
1583: return XDP_TYPES.WORKITEM_LIST
1584: IS
1585: lv_list XDP_TYPES.WORKITEM_LIST;
1586: lv_index number;
1587: lv_err varchar2(4000);

Line 1585: lv_list XDP_TYPES.WORKITEM_LIST;

1581: Function Get_Workitem_List(
1582: p_sdp_order_id NUMBER)
1583: return XDP_TYPES.WORKITEM_LIST
1584: IS
1585: lv_list XDP_TYPES.WORKITEM_LIST;
1586: lv_index number;
1587: lv_err varchar2(4000);
1588: lv_ret number;
1589: lv_str varchar2(2000);

Line 1590: lv_err_list XDP_TYPES.MESSAGE_LIST;

1586: lv_index number;
1587: lv_err varchar2(4000);
1588: lv_ret number;
1589: lv_str varchar2(2000);
1590: lv_err_list XDP_TYPES.MESSAGE_LIST;
1591: CURSOR lc_wi IS
1592: select
1593: fwt.workitem_instance_id,
1594: fwt.workitem_id,

Line 1665: return XDP_TYPES.FULFILLMENT_ACTION_LIST

1661: for the given workitem.
1662: */
1663: Function Get_FA_List(
1664: p_wi_instance_id NUMBER)
1665: return XDP_TYPES.FULFILLMENT_ACTION_LIST
1666: IS
1667: lv_list XDP_TYPES.FULFILLMENT_ACTION_LIST;
1668: lv_index number;
1669: lv_err varchar2(4000);

Line 1667: lv_list XDP_TYPES.FULFILLMENT_ACTION_LIST;

1663: Function Get_FA_List(
1664: p_wi_instance_id NUMBER)
1665: return XDP_TYPES.FULFILLMENT_ACTION_LIST
1666: IS
1667: lv_list XDP_TYPES.FULFILLMENT_ACTION_LIST;
1668: lv_index number;
1669: lv_err varchar2(4000);
1670: lv_ret number;
1671: lv_str varchar2(2000);

Line 1672: lv_err_list XDP_TYPES.MESSAGE_LIST;

1668: lv_index number;
1669: lv_err varchar2(4000);
1670: lv_ret number;
1671: lv_str varchar2(2000);
1672: lv_err_list XDP_TYPES.MESSAGE_LIST;
1673: lv_index2 binary_integer;
1674:
1675: lv_error_type varchar2(30);
1676: lv_date DATE;

Line 1743: return XDP_TYPES.FA_COMMAND_AUDIT_TRAIL

1739: given FA and the responds SFM received from the FE
1740: */
1741: Function Get_FA_AUDIT_TRAILS(
1742: p_fa_instance_id NUMBER)
1743: return XDP_TYPES.FA_COMMAND_AUDIT_TRAIL
1744: IS
1745: lv_list XDP_TYPES.FA_COMMAND_AUDIT_TRAIL;
1746: lv_index number;
1747: CURSOR lc_fe IS

Line 1745: lv_list XDP_TYPES.FA_COMMAND_AUDIT_TRAIL;

1741: Function Get_FA_AUDIT_TRAILS(
1742: p_fa_instance_id NUMBER)
1743: return XDP_TYPES.FA_COMMAND_AUDIT_TRAIL
1744: IS
1745: lv_list XDP_TYPES.FA_COMMAND_AUDIT_TRAIL;
1746: lv_index number;
1747: CURSOR lc_fe IS
1748: select
1749: fcl.fa_instance_id,