DBA Data[Home] [Help]

APPS.WSH_INTERFACE_GRP dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 959: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type

955: x_msg_data OUT NOCOPY VARCHAR2,
956:
957: -- Procedure specific Parameters
958: p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
959: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
960: ,
961: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
962: ) IS
963:

Line 961: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type

957: -- Procedure specific Parameters
958: p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
959: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
960: ,
961: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
962: ) IS
963:
964: l_api_name CONSTANT VARCHAR2(30) := 'delivery_detail_action';
965: l_api_version CONSTANT NUMBER := 1.0;

Line 974: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

970: l_msg_data VARCHAR2(32767);
971: l_program_name VARCHAR2(32767);
972: --
973: --
974: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
975: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
976: ;
977: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
978: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;

Line 975: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type

971: l_program_name VARCHAR2(32767);
972: --
973: --
974: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
975: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
976: ;
977: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
978: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
979: l_dummy_flag VARCHAR2(32767);

Line 977: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

973: --
974: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
975: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
976: ;
977: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
978: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
979: l_dummy_flag VARCHAR2(32767);
980: --
981: CURSOR det_cur(p_det_id NUMBER) IS

Line 978: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;

974: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
975: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
976: ;
977: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
978: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
979: l_dummy_flag VARCHAR2(32767);
980: --
981: CURSOR det_cur(p_det_id NUMBER) IS
982: SELECT released_status,

Line 1228: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

1224: --
1225: END Delivery_Detail_Action;
1226:
1227: PROCEDURE Rtrim_details_blank_space (
1228: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
1229: p_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type) IS
1230: l_debug_on BOOLEAN;
1231: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||
1232: G_PKG_NAME || '.' || 'Rtrim_details_blank_space';

Line 1229: p_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type) IS

1225: END Delivery_Detail_Action;
1226:
1227: PROCEDURE Rtrim_details_blank_space (
1228: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
1229: p_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type) IS
1230: l_debug_on BOOLEAN;
1231: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||
1232: G_PKG_NAME || '.' || 'Rtrim_details_blank_space';
1233: BEGIN

Line 1375: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

1371: x_msg_count OUT NOCOPY NUMBER,
1372: x_msg_data OUT NOCOPY VARCHAR2,
1373:
1374: -- Procedure Specific Parameters
1375: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
1376: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
1377: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
1378: ) IS
1379:

Line 1376: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

1372: x_msg_data OUT NOCOPY VARCHAR2,
1373:
1374: -- Procedure Specific Parameters
1375: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
1376: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
1377: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
1378: ) IS
1379:
1380: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Delivery_Detail';

Line 1377: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType

1373:
1374: -- Procedure Specific Parameters
1375: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
1376: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
1377: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
1378: ) IS
1379:
1380: l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Delivery_Detail';
1381: l_api_version CONSTANT NUMBER := 1.0;

Line 1396: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type

1392: l_counter NUMBER := 0;
1393:
1394: l_valid_index_tab wsh_util_core.id_tab_type;
1395: l_delivery_id NUMBER;
1396: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type
1397: ;
1398: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1399: l_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1400: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

Line 1398: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

1394: l_valid_index_tab wsh_util_core.id_tab_type;
1395: l_delivery_id NUMBER;
1396: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type
1397: ;
1398: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1399: l_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1400: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1401: l_index NUMBER;
1402: --

Line 1399: l_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

1395: l_delivery_id NUMBER;
1396: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type
1397: ;
1398: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1399: l_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1400: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1401: l_index NUMBER;
1402: --
1403: CURSOR det_to_del_cur(p_detail_id NUMBER) IS

Line 1400: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

1396: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type
1397: ;
1398: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1399: l_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1400: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1401: l_index NUMBER;
1402: --
1403: CURSOR det_to_del_cur(p_detail_id NUMBER) IS
1404: SELECT wda.delivery_id