APPS.PJM_UEFF_ONHAND dependencies on PJM_UNIT_EFF

Line 44: if ( pjm_unit_eff.enabled = 'N' ) then

40: BEGIN
41:
42: L_quantity := 0; -- BUG fix 2752979
43:
44: if ( pjm_unit_eff.enabled = 'N' ) then
45: return ( 0 );
46: end if;
47:
48: if ( pjm_unit_eff.unit_effective_item

Line 48: if ( pjm_unit_eff.unit_effective_item

44: if ( pjm_unit_eff.enabled = 'N' ) then
45: return ( 0 );
46: end if;
47:
48: if ( pjm_unit_eff.unit_effective_item
49: ( X_item_id, X_organization_id ) = 'N' ) then
50: return ( 0 );
51: end if;
52:

Line 53: L_unit_number := PJM_UNIT_EFF.OE_Line_Unit_Number_Cached(X_source_line);

49: ( X_item_id, X_organization_id ) = 'N' ) then
50: return ( 0 );
51: end if;
52:
53: L_unit_number := PJM_UNIT_EFF.OE_Line_Unit_Number_Cached(X_source_line);
54: --Bug #4726150
55: --For requisition move orders, unit number is mandatory for unit effective items
56: --and hence we need to use this table to derive l_unit_number
57: IF (l_unit_number IS NULL) THEN

Line 134: if ( pjm_unit_eff.enabled = 'N' ) then

130: L_unit_number PJM_UNIT_NUMBERS.UNIT_NUMBER%TYPE;
131:
132: BEGIN
133:
134: if ( pjm_unit_eff.enabled = 'N' ) then
135: return ( NULL );
136: end if;
137:
138: if ( X_Fetch_From_DB = 'Y' ) then

Line 169: if ( pjm_unit_eff.unit_effective_item

165: L_trx_sign := X_trx_sign;
166:
167: end if;
168:
169: if ( pjm_unit_eff.unit_effective_item
170: ( L_item_id, L_organization_id ) = 'N' ) then
171: return ( NULL );
172: end if;
173:

Line 174: L_unit_number := PJM_UNIT_EFF.OE_Line_Unit_Number_Cached(X_source_line);

170: ( L_item_id, L_organization_id ) = 'N' ) then
171: return ( NULL );
172: end if;
173:
174: L_unit_number := PJM_UNIT_EFF.OE_Line_Unit_Number_Cached(X_source_line);
175:
176: if ( L_src_type_id = 5 ) then
177:
178: --

Line 182: PJM_UNIT_EFF.WIP_Unit_Number(L_trx_src_id, L_organization_id) ) then

178: --
179: -- Transaction Source is WIP; get the unit number from the WIP header
180: --
181: if ( L_unit_number =
182: PJM_UNIT_EFF.WIP_Unit_Number(L_trx_src_id, L_organization_id) ) then
183: return ( NULL ); -- NULL means quantity from transaction
184: else
185: return ( 0 );
186: end if;

Line 194: if ( L_unit_number = PJM_UNIT_EFF.RCV_Unit_Number(L_rcv_trx_id) ) then

190: --
191: -- Transaction Source is PO/Internal Req; get the unit number from PO
192: -- distribution or PO req distribution through RCV transaction
193: --
194: if ( L_unit_number = PJM_UNIT_EFF.RCV_Unit_Number(L_rcv_trx_id) ) then
195: return ( NULL ); -- NULL means quantity from transaction
196: else
197: return ( 0 );
198: end if;

Line 225: PJM_UNIT_EFF.OE_Line_Unit_Number_Cached(L_trx_src_line_id) ) then

221: AND rownum = 1;
222:
223: if ( L_trx_qty = 0 ) then
224: if ( L_unit_number =
225: PJM_UNIT_EFF.OE_Line_Unit_Number_Cached(L_trx_src_line_id) ) then
226: return ( NULL ); -- NULL means quantity from transaction
227: else
228: return ( 0 );
229: end if;