APPS.INV_MGD_MVT_STATS_PVT dependencies on FND_PROFILE

Line 619: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);

615: );
616: END IF;
617:
618: x_movement_transaction.last_updated_by :=
619: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
620: x_movement_transaction.creation_date := SYSDATE;
621: x_movement_transaction.last_update_date := SYSDATE;
622: x_movement_transaction.created_by :=
623: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);

Line 623: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);

619: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
620: x_movement_transaction.creation_date := SYSDATE;
621: x_movement_transaction.last_update_date := SYSDATE;
622: x_movement_transaction.created_by :=
623: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
624: x_movement_transaction.last_update_login :=
625: NVL(TO_NUMBER(fnd_profile.value('LOGIN_ID')),0);
626: x_movement_transaction.weight_method := 'S';
627: x_movement_transaction.stat_method := 'S';

Line 625: NVL(TO_NUMBER(fnd_profile.value('LOGIN_ID')),0);

621: x_movement_transaction.last_update_date := SYSDATE;
622: x_movement_transaction.created_by :=
623: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
624: x_movement_transaction.last_update_login :=
625: NVL(TO_NUMBER(fnd_profile.value('LOGIN_ID')),0);
626: x_movement_transaction.weight_method := 'S';
627: x_movement_transaction.stat_method := 'S';
628: -- x_movement_transaction.creation_method := 'A';
629: IF NVL(x_movement_transaction.movement_status,'N') = 'N' THEN

Line 993: ( TO_NUMBER(FND_PROFILE.Value('USER_ID'))

989: , movement_status = P_MOVEMENT_STATISTICS.movement_status
990: , transaction_date = P_MOVEMENT_STATISTICS.transaction_date
991: , last_update_date = SYSDATE
992: , last_updated_by = NVL
993: ( TO_NUMBER(FND_PROFILE.Value('USER_ID'))
994: , last_updated_by
995: )
996: , last_update_login = NVL
997: ( TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))

Line 997: ( TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))

993: ( TO_NUMBER(FND_PROFILE.Value('USER_ID'))
994: , last_updated_by
995: )
996: , last_update_login = NVL
997: ( TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
998: , last_update_login
999: )
1000: , document_source_type = P_MOVEMENT_STATISTICS.document_source_type
1001: , creation_method = P_MOVEMENT_STATISTICS.creation_method