DBA Data[Home] [Help]

APPS.WSH_INTERFACE_GRP dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 955: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type

951: x_msg_data OUT NOCOPY VARCHAR2,
952:
953: -- Procedure specific Parameters
954: p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
955: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
956: ,
957: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
958: ) IS
959:

Line 957: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type

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

Line 970: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

966: l_msg_data VARCHAR2(32767);
967: l_program_name VARCHAR2(32767);
968: --
969: --
970: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
971: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
972: ;
973: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
974: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;

Line 971: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type

967: l_program_name VARCHAR2(32767);
968: --
969: --
970: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
971: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
972: ;
973: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
974: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
975: l_dummy_flag VARCHAR2(32767);

Line 973: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

969: --
970: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
971: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
972: ;
973: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
974: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
975: l_dummy_flag VARCHAR2(32767);
976: --
977: CURSOR det_cur(p_det_id NUMBER) IS

Line 974: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;

970: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
971: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
972: ;
973: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
974: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
975: l_dummy_flag VARCHAR2(32767);
976: --
977: CURSOR det_cur(p_det_id NUMBER) IS
978: SELECT released_status,

Line 1224: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

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

Line 1225: p_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type) IS

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

Line 1371: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

1367: x_msg_count OUT NOCOPY NUMBER,
1368: x_msg_data OUT NOCOPY VARCHAR2,
1369:
1370: -- Procedure Specific Parameters
1371: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
1372: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
1373: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
1374: ) IS
1375:

Line 1372: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

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

Line 1373: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType

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

Line 1392: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type

1388: l_counter NUMBER := 0;
1389:
1390: l_valid_index_tab wsh_util_core.id_tab_type;
1391: l_delivery_id NUMBER;
1392: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type
1393: ;
1394: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1395: l_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1396: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

Line 1394: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

1390: l_valid_index_tab wsh_util_core.id_tab_type;
1391: l_delivery_id NUMBER;
1392: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type
1393: ;
1394: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1395: l_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1396: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1397: l_index NUMBER;
1398: --

Line 1395: l_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

1391: l_delivery_id NUMBER;
1392: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type
1393: ;
1394: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1395: l_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1396: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1397: l_index NUMBER;
1398: --
1399: CURSOR det_to_del_cur(p_detail_id NUMBER) IS

Line 1396: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

1392: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type
1393: ;
1394: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1395: l_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1396: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1397: l_index NUMBER;
1398: --
1399: CURSOR det_to_del_cur(p_detail_id NUMBER) IS
1400: SELECT wda.delivery_id