DBA Data[Home] [Help]

APPS.WSH_ORG_CARRIER_SERVICES_PKG dependencies on WSH_ORG_CARRIER_SERVICES

Line 1: PACKAGE BODY WSH_ORG_CARRIER_SERVICES_PKG as

1: PACKAGE BODY WSH_ORG_CARRIER_SERVICES_PKG as
2: /* $Header: WSHOCTHB.pls 120.1.12000000.2 2007/07/20 06:08:51 jnpinto ship $ */
3:
4: --- Package Name: WSH_ORG_CARRIER_SERVICES_PKG
5: --- Pupose: Table Handlers for table WSH_ORG_CARRIER_SERVICES

Line 4: --- Package Name: WSH_ORG_CARRIER_SERVICES_PKG

1: PACKAGE BODY WSH_ORG_CARRIER_SERVICES_PKG as
2: /* $Header: WSHOCTHB.pls 120.1.12000000.2 2007/07/20 06:08:51 jnpinto ship $ */
3:
4: --- Package Name: WSH_ORG_CARRIER_SERVICES_PKG
5: --- Pupose: Table Handlers for table WSH_ORG_CARRIER_SERVICES
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --

Line 5: --- Pupose: Table Handlers for table WSH_ORG_CARRIER_SERVICES

1: PACKAGE BODY WSH_ORG_CARRIER_SERVICES_PKG as
2: /* $Header: WSHOCTHB.pls 120.1.12000000.2 2007/07/20 06:08:51 jnpinto ship $ */
3:
4: --- Package Name: WSH_ORG_CARRIER_SERVICES_PKG
5: --- Pupose: Table Handlers for table WSH_ORG_CARRIER_SERVICES
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ORG_CARRIER_SERVICES_PKG';

Line 9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ORG_CARRIER_SERVICES_PKG';

5: --- Pupose: Table Handlers for table WSH_ORG_CARRIER_SERVICES
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ORG_CARRIER_SERVICES_PKG';
10: --
11: PROCEDURE Assign_Org_Carrier_Service
12: (
13: p_org_Carrier_Service_Info IN OCSRecType

Line 30: SELECT wsh_org_Carrier_Services_s.nextval

26: IS
27:
28: CURSOR C_Next_id
29: IS
30: SELECT wsh_org_Carrier_Services_s.nextval
31: FROM sys.dual;
32:
33:
34: CURSOR C_New_Rowid(p_org_carrier_service_id NUMBER)

Line 37: FROM WSH_org_Carrier_ServiceS

33:
34: CURSOR C_New_Rowid(p_org_carrier_service_id NUMBER)
35: IS
36: SELECT rowid
37: FROM WSH_org_Carrier_ServiceS
38: WHERE org_Carrier_Service_id = p_org_Carrier_Service_id;
39:
40: --- Bug 2796816
41: CURSOR c_distribution_account(p_freight_code varchar2,p_organization_id number) is

Line 50: FROM wsh_org_carrier_services wocs,

46:
47: CURSOR c_service_exists
48: (p_carrier_service_id number,p_freight_code varchar2,p_organization_id number) is
49: SELECT 'Y'
50: FROM wsh_org_carrier_services wocs,
51: wsh_carrier_services_v wcs,
52: wsh_carriers_v wc
53: WHERE wc.carrier_id = wcs.carrier_id
54: and wocs.carrier_service_id = wcs.carrier_service_id

Line 124: l_procedure := 'Inserting into Wsh_org_carrier_services';

120: FETCH C_Next_id INTO l_Org_Carrier_Service_Id;
121: CLOSE C_Next_id;
122:
123: l_position := 10;
124: l_procedure := 'Inserting into Wsh_org_carrier_services';
125:
126: --
127: IF l_debug_on THEN
128: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 128: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);

124: l_procedure := 'Inserting into Wsh_org_carrier_services';
125:
126: --
127: IF l_debug_on THEN
128: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);
129: END IF;
130: --
131:
132: INSERT INTO wsh_org_Carrier_Services

Line 132: INSERT INTO wsh_org_Carrier_Services

128: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);
129: END IF;
130: --
131:
132: INSERT INTO wsh_org_Carrier_Services
133: ( org_Carrier_Service_id,
134: carrier_service_id,
135: organization_id,
136: enabled_flag,

Line 307: WSH_DEBUG_SV.logmsg(l_module_name,'Updating WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);

303: ELSE
304:
305: --
306: IF l_debug_on THEN
307: WSH_DEBUG_SV.logmsg(l_module_name,'Updating WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);
308: END IF;
309: --
310: L_POSITION := 20;
311: L_PROCEDURE := 'Updating WSH_ORG_CARRIER_SERVICES';

Line 311: L_PROCEDURE := 'Updating WSH_ORG_CARRIER_SERVICES';

307: WSH_DEBUG_SV.logmsg(l_module_name,'Updating WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);
308: END IF;
309: --
310: L_POSITION := 20;
311: L_PROCEDURE := 'Updating WSH_ORG_CARRIER_SERVICES';
312:
313: UPDATE wsh_Org_Carrier_Services
314: SET
315: enabled_flag = p_org_Carrier_Service_Info.Enabled_Flag,

Line 313: UPDATE wsh_Org_Carrier_Services

309: --
310: L_POSITION := 20;
311: L_PROCEDURE := 'Updating WSH_ORG_CARRIER_SERVICES';
312:
313: UPDATE wsh_Org_Carrier_Services
314: SET
315: enabled_flag = p_org_Carrier_Service_Info.Enabled_Flag,
316: attribute_category = p_org_Carrier_Service_Info.Attribute_Category,
317: attribute1 = p_org_Carrier_Service_Info.Attribute1,

Line 540: FROM wsh_Org_Carrier_Services

536: IS
537:
538: CURSOR C_lock_row IS
539: SELECT *
540: FROM wsh_Org_Carrier_Services
541: WHERE rowid = p_rowid
542: FOR UPDATE of Org_Carrier_Service_id NOWAIT;
543:
544: Recinfo C_lock_row%ROWTYPE;

Line 660: WSH_UTIL_CORE.Default_Handler('WSH_org_Carrier_ServiceS_PKG.LockOrg_Carrier_Service',l_module_name);

656: --
657: EXCEPTION
658: WHEN others THEN
659: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
660: WSH_UTIL_CORE.Default_Handler('WSH_org_Carrier_ServiceS_PKG.LockOrg_Carrier_Service',l_module_name);
661: --
662: IF l_debug_on THEN
663: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 669: END WSH_ORG_CARRIER_SERVICES_PKG;

665: END IF;
666: --
667: END Lock_Org_Carrier_Service;
668:
669: END WSH_ORG_CARRIER_SERVICES_PKG;