APPS.WSH_PARAMETERS_PVT dependencies on WSH_PARAMETERS

Line 1: PACKAGE BODY WSH_PARAMETERS_PVT as

1: PACKAGE BODY WSH_PARAMETERS_PVT as
2: /* $Header: WSHUPRMB.pls 115.2 99/07/16 08:23:22 porting ship $ */
3:
4: X_ROW_FETCHED NUMBER := 0;
5: CUR_ORGANIZATION_ID NUMBER := 0;

Line 32: From wsh_parameters

28: nvl(DEPARTURE_REPORT_SET_ID, 0), nvl(DELIVERY_REPORT_SET_ID, 0),
29: RELEASE_SEQ_RULE_ID, PICK_SLIP_RULE_ID,
30: nvl(PRINT_PICK_SLIP_MODE,''), PICK_RELEASE_REPORT_SET_ID,
31: ENFORCE_PACKING_FLAG
32: From wsh_parameters
33: Where organization_id = x_organization_id;
34:
35: Begin
36: OPEN C (CUR_ORGANIZATION_ID);

Line 63: | Purpose: To get the value of a parameter from wsh_parameters table |

59: --
60:
61: /*===========================================================================+
62: | Name: get_param_value |
63: | Purpose: To get the value of a parameter from wsh_parameters table |
64: +===========================================================================*/
65:
66: PROCEDURE get_param_value(x_organization_id IN NUMBER,
67: param_name IN VARCHAR2,

Line 73: wsh_parameters_pvt.x_fetch_row;

69: BEGIN
70: if (( x_organization_id <> CUR_ORGANIZATION_ID ) OR
71: ( x_row_fetched = 0 )) Then
72: CUR_ORGANIZATION_ID := x_organization_id;
73: wsh_parameters_pvt.x_fetch_row;
74: x_row_fetched := 1;
75: end if;
76: if ( param_name = 'PLANNING_METHOD_FLAG') Then
77: param_value := X_PLANNING_METHOD_FLAG;

Line 106: wsh_parameters_pvt.x_fetch_row;

102: BEGIN
103: if (( x_organization_id <> CUR_ORGANIZATION_ID ) OR
104: ( x_row_fetched = 0 )) Then
105: CUR_ORGANIZATION_ID := x_organization_id;
106: wsh_parameters_pvt.x_fetch_row;
107: x_row_fetched := 1;
108: end if;
109: if ( param_name = 'DEPARTURE_REPORT_SET_ID') Then
110: param_value := X_DEPARTURE_REPORT_SET_ID;

Line 122: END WSH_PARAMETERS_PVT;

118: param_value := X_PICK_SLIP_RULE_ID;
119: end if;
120: END get_param_value_num;
121:
122: END WSH_PARAMETERS_PVT;