APPS.GMI_ALLOCATE_INVENTORY_PVT dependencies on FND_PROFILE

Line 162: l_IC$DEFAULT_LOCT := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

158: gmi_reservation_util.println('OPM Allocation Engine - start allocate line',1);
159:
160: /*Get required system constants
161: ==============================*/
162: l_IC$DEFAULT_LOCT := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
163: l_overpick_enabled := FND_PROFILE.VALUE('WSH_OVERPICK_ENABLED');
164:
165: /* dbms_output.put_line('default loct is ' || l_IC$DEFAULT_LOCT); */
166: /* NC */

Line 163: l_overpick_enabled := FND_PROFILE.VALUE('WSH_OVERPICK_ENABLED');

159:
160: /*Get required system constants
161: ==============================*/
162: l_IC$DEFAULT_LOCT := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
163: l_overpick_enabled := FND_PROFILE.VALUE('WSH_OVERPICK_ENABLED');
164:
165: /* dbms_output.put_line('default loct is ' || l_IC$DEFAULT_LOCT); */
166: /* NC */
167: IF (NVL(p_batch_id,0) <> 0) THEN

Line 1051: IC$DEFAULT_LOCT := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

1047: /*Initialize return status to success
1048: ====================================*/
1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1050:
1051: IC$DEFAULT_LOCT := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
1052:
1053: /* dbms_output.put_line('DEFAULT LOT retrieved as '|| IC$DEFAULT_LOCT); */
1054:
1055: /*Determine whether or not a row exists for the DEFAULT LOT

Line 1302: IC$DEFAULT_LOCT := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

1298: END IF;
1299: CLOSE ic_tran_pnd_c1;
1300: ELSIF (p_item_loct_ctl > 0 OR p_whse_loct_ctl > 0) THEN
1301: /* dbms_output.put_line('check allocations for location control '); */
1302: IC$DEFAULT_LOCT := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
1303: OPEN ic_tran_pnd_c2;
1304: FETCH ic_tran_pnd_c2 into l_sum_trans_qty;
1305: IF (ic_tran_pnd_c2%NOTFOUND) THEN
1306: l_sum_trans_qty :=0;

Line 1367: IC$DEFAULT_LOCT VARCHAR2(255) := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

1363: RETURN BOOLEAN
1364: IS
1365: l_api_name CONSTANT VARCHAR2 (30) := 'ALLOCATIONS_EXIST';
1366: l_sum_trans_qty NUMBER;
1367: IC$DEFAULT_LOCT VARCHAR2(255) := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
1368:
1369: CURSOR ic_tran_pnd_c1 IS
1370: SELECT /*+ INDEX (ic_tran_pnd, ic_tran_pndi3) */
1371: sum(trans_qty)