APPS.INV_MGD_MVT_STATS_PVT dependencies on FND_PROFILE

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

595: );
596: END IF;
597:
598: x_movement_transaction.last_updated_by :=
599: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
600: x_movement_transaction.creation_date := SYSDATE;
601: x_movement_transaction.last_update_date := SYSDATE;
602: x_movement_transaction.created_by :=
603: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);

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

599: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
600: x_movement_transaction.creation_date := SYSDATE;
601: x_movement_transaction.last_update_date := SYSDATE;
602: x_movement_transaction.created_by :=
603: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
604: x_movement_transaction.last_update_login :=
605: NVL(TO_NUMBER(fnd_profile.value('LOGIN_ID')),0);
606: x_movement_transaction.weight_method := 'S';
607: x_movement_transaction.stat_method := 'S';

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

601: x_movement_transaction.last_update_date := SYSDATE;
602: x_movement_transaction.created_by :=
603: NVL(TO_NUMBER(fnd_profile.value('USER_ID')),0);
604: x_movement_transaction.last_update_login :=
605: NVL(TO_NUMBER(fnd_profile.value('LOGIN_ID')),0);
606: x_movement_transaction.weight_method := 'S';
607: x_movement_transaction.stat_method := 'S';
608: -- x_movement_transaction.creation_method := 'A';
609: IF NVL(x_movement_transaction.movement_status,'N') = 'N' THEN

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

949: , movement_status = P_MOVEMENT_STATISTICS.movement_status
950: , transaction_date = P_MOVEMENT_STATISTICS.transaction_date
951: , last_update_date = SYSDATE
952: , last_updated_by = NVL
953: ( TO_NUMBER(FND_PROFILE.Value('USER_ID'))
954: , last_updated_by
955: )
956: , last_update_login = NVL
957: ( TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))

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

953: ( TO_NUMBER(FND_PROFILE.Value('USER_ID'))
954: , last_updated_by
955: )
956: , last_update_login = NVL
957: ( TO_NUMBER(FND_PROFILE.Value('LOGIN_ID'))
958: , last_update_login
959: )
960: , document_source_type = P_MOVEMENT_STATISTICS.document_source_type
961: , creation_method = P_MOVEMENT_STATISTICS.creation_method