APPS.WMS_TASK_DISPATCH_LOV dependencies on FND_GLOBAL

Line 985: mydebug('In GET_LPN_ITEMS_LOV fnd_global.resp_id:' || fnd_global.resp_id || '...fnd_profile.value_wnps_INV_TRANS_REASON_SECURITY:'||fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'));

981: p_txn_type_id IN NUMBER ) IS
982:
983:
984: BEGIN
985: mydebug('In GET_LPN_ITEMS_LOV fnd_global.resp_id:' || fnd_global.resp_id || '...fnd_profile.value_wnps_INV_TRANS_REASON_SECURITY:'||fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'));
986: mydebug('In p_txn_type_id :' || p_txn_type_id);
987: OPEN x_reasons FOR
988: SELECT reason_name,description, reason_id
989: FROM mtl_transaction_reasons

Line 997: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )

993: -- nsrivast, invconv , transaction reason security
994: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
995: OR
996: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
997: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
998: AND
999: ( mtrs.transaction_type_id = p_txn_type_id OR NVL(mtrs.transaction_type_id, -1) = -1 )
1000: )-- where ends
1001: )-- select ends

Line 1580: mydebug('fnd_global.resp_id: '|| fnd_global.resp_id);

1576: mydebug('p_reason_type: '|| p_reason_type);
1577: mydebug('p_reason_contexts: '|| p_reason_contexts);
1578: mydebug('p_concat_segments: '|| p_concat_segments);
1579: mydebug('p_txn_type_id: '|| p_txn_type_id);
1580: mydebug('fnd_global.resp_id: '|| fnd_global.resp_id);
1581: END IF;
1582: -- end 14319939
1583: WHILE l_context_count < Length(p_reason_contexts) LOOP
1584: l_context := Substr(p_reason_contexts, l_context_count, 2);

Line 1629: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )

1625: -- nsrivast, invconv , transaction reason security
1626: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
1627: OR
1628: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
1629: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
1630: AND
1631: ( mtrs.transaction_type_id = p_txn_type_id OR NVL(mtrs.transaction_type_id, -1) = -1 )
1632: )-- where ends
1633: )-- select ends

Line 1686: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )

1682: -- nsrivast, invconv , transaction reason security
1683: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
1684: OR
1685: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
1686: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
1687: AND
1688: ( mtrs.transaction_type_id = p_txn_type_id OR NVL(mtrs.transaction_type_id, -1) = -1 )
1689: )-- where ends
1690: )-- select ends