APPS.WSH_REPORTS_MLS_LANG dependencies on DBMS_SQL

Line 70: l_CursorID := DBMS_SQL.OPEN_CURSOR;

66: END IF;
67: END IF;
68:
69: -- Open the cursor for processing
70: l_CursorID := DBMS_SQL.OPEN_CURSOR;
71:
72: -- Parse the query
73: DBMS_SQL.PARSE(l_CursorID, v_SelectStmt, DBMS_SQL.V7);
74:

Line 73: DBMS_SQL.PARSE(l_CursorID, v_SelectStmt, DBMS_SQL.V7);

69: -- Open the cursor for processing
70: l_CursorID := DBMS_SQL.OPEN_CURSOR;
71:
72: -- Parse the query
73: DBMS_SQL.PARSE(l_CursorID, v_SelectStmt, DBMS_SQL.V7);
74:
75: -- Bind input variables
76: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_warehouse_id',v_warehouse_id);
77: IF v_departure_id IS NOT NULL THEN

Line 76: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_warehouse_id',v_warehouse_id);

72: -- Parse the query
73: DBMS_SQL.PARSE(l_CursorID, v_SelectStmt, DBMS_SQL.V7);
74:
75: -- Bind input variables
76: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_warehouse_id',v_warehouse_id);
77: IF v_departure_id IS NOT NULL THEN
78: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_id',v_departure_id);
79: END IF;
80: IF v_departure_date_lo IS NOT NULL THEN

Line 78: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_id',v_departure_id);

74:
75: -- Bind input variables
76: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_warehouse_id',v_warehouse_id);
77: IF v_departure_id IS NOT NULL THEN
78: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_id',v_departure_id);
79: END IF;
80: IF v_departure_date_lo IS NOT NULL THEN
81: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_date_lo',v_departure_date_lo);
82: END IF;

Line 81: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_date_lo',v_departure_date_lo);

77: IF v_departure_id IS NOT NULL THEN
78: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_id',v_departure_id);
79: END IF;
80: IF v_departure_date_lo IS NOT NULL THEN
81: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_date_lo',v_departure_date_lo);
82: END IF;
83: IF v_departure_date_hi IS NOT NULL THEN
84: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_date_hi',v_departure_date_hi);
85: END IF;

Line 84: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_date_hi',v_departure_date_hi);

80: IF v_departure_date_lo IS NOT NULL THEN
81: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_date_lo',v_departure_date_lo);
82: END IF;
83: IF v_departure_date_hi IS NOT NULL THEN
84: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_date_hi',v_departure_date_hi);
85: END IF;
86: IF v_freight_carrier IS NOT NULL THEN
87: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_freight_carrier',v_freight_carrier);
88: END IF;

Line 87: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_freight_carrier',v_freight_carrier);

83: IF v_departure_date_hi IS NOT NULL THEN
84: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_departure_date_hi',v_departure_date_hi);
85: END IF;
86: IF v_freight_carrier IS NOT NULL THEN
87: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_freight_carrier',v_freight_carrier);
88: END IF;
89: IF v_delivery_id IS NOT NULL THEN
90: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_delivery_id',v_delivery_id);
91: END IF;

Line 90: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_delivery_id',v_delivery_id);

86: IF v_freight_carrier IS NOT NULL THEN
87: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_freight_carrier',v_freight_carrier);
88: END IF;
89: IF v_delivery_id IS NOT NULL THEN
90: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_delivery_id',v_delivery_id);
91: END IF;
92:
93: -- Define the output variable
94: DBMS_SQL.DEFINE_COLUMN(l_CursorID,1,l_lang,30);

Line 94: DBMS_SQL.DEFINE_COLUMN(l_CursorID,1,l_lang,30);

90: DBMS_SQL.BIND_VARIABLE(l_CursorID,':v_delivery_id',v_delivery_id);
91: END IF;
92:
93: -- Define the output variable
94: DBMS_SQL.DEFINE_COLUMN(l_CursorID,1,l_lang,30);
95:
96: -- Execute the query
97: l_dummy := DBMS_SQL.EXECUTE(l_CursorID);
98:

Line 97: l_dummy := DBMS_SQL.EXECUTE(l_CursorID);

93: -- Define the output variable
94: DBMS_SQL.DEFINE_COLUMN(l_CursorID,1,l_lang,30);
95:
96: -- Execute the query
97: l_dummy := DBMS_SQL.EXECUTE(l_CursorID);
98:
99: -- Create string of languages to be returned
100: LOOP
101: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN

Line 101: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN

97: l_dummy := DBMS_SQL.EXECUTE(l_CursorID);
98:
99: -- Create string of languages to be returned
100: LOOP
101: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN
102: EXIT;
103: END IF;
104:
105: -- Fetch language into variable

Line 106: DBMS_SQL.COLUMN_VALUE(l_CursorID,1,l_lang);

102: EXIT;
103: END IF;
104:
105: -- Fetch language into variable
106: DBMS_SQL.COLUMN_VALUE(l_CursorID,1,l_lang);
107:
108: IF (l_lang IS NOT NULL) THEN
109: IF (l_lang_str IS NULL) THEN
110: l_lang_str := l_lang;

Line 127: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

123: END IF;
124: END IF;
125: END LOOP;
126:
127: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
128:
129: IF (l_lang_str IS NULL) THEN
130: -- Function must not return an empty string
131: l_lang_str := l_base_lang;

Line 138: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

134: RETURN (l_lang_str);
135:
136: EXCEPTION
137: WHEN OTHERS THEN
138: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
139: RAISE;
140: END GET_LANG;
141: END WSH_REPORTS_MLS_LANG;